Re: Logical Replication postgres 10.5

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Logical Replication postgres 10.5
Дата
Msg-id 9cb8862470c05723f45ac841374a301c9149a9b0.camel@cybertec.at
обсуждение исходный текст
Ответ на Logical Replication postgres 10.5  (Mai Peng <maily.peng@webedia-group.com>)
Список pgsql-admin
Please always include the mailing list in your replies.

Mai Peng wrote:
> Le 28 mai 2019 à 07:59, Laurenz Albe <laurenz.albe@cybertec.at> a écrit:
> 
> > On Tue, 2019-05-28 at 07:21 +0200, Mai Peng wrote:
> > > Is Logical Replication ignore foreign key constraint ? How does it possible ?
> > 
> > Can you specify what you mean by "ignoring foreign key constraints"?
> > Like, some SQL that demonstrates what you are talking about.
>
> The table that stores primary keys is empty, and the table with foreign keys still replicates.

That is because "session_replication_role" is set to "replica" when changes
are replicated.  This prevents foreign key constraints from being checked.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




В списке pgsql-admin по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Logical Replication postgres 10.5
Следующее
От: Павел Красиков
Дата:
Сообщение: Empty white window