| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Mai Peng <maily(dot)peng(at)webedia-group(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Logical Replication postgres 10.5 |
| Date: | 2019-05-28 08:09:23 |
| Message-ID: | 9cb8862470c05723f45ac841374a301c9149a9b0.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Please always include the mailing list in your replies.
Mai Peng wrote:
> Le 28 mai 2019 à 07:59, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Павел Красиков | 2019-05-28 21:47:01 | Empty white window |
| Previous Message | Achilleas Mantzios | 2019-05-28 07:19:46 | Re: Logical Replication postgres 10.5 |