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