Please always include the mailing list in your replies. Mai Peng wrote: > Le 28 mai 2019 à 07:59, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
