Postgres Pro
Downloads
Home   >   mailing lists

Re: Support for Deferred Constraints in PG15 Logical Replication - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Support for Deferred Constraints in PG15 Logical Replication
Date
Msg-id 2df60a8f29d4d60ef54e59f7c945f2e5ab0d9a42.camel@cybertec.at
Whole thread Raw
In response to Support for Deferred Constraints in PG15 Logical Replication  (Jitesh Srivastava <jitesh.srivastava@gmail.com>)
List pgsql-general
Tree view 
On Fri, 2023-08-25 at 00:28 +0200, Jitesh Srivastava wrote:
> I'm interested in finding out whether logical replication in PostgreSQL 15 includes support for deferrable unique
constraints. 

You can have deferrable constraints on both ends, yes.

If you wonder whether SET CONSTRAINTS ALL DEFERRED is replicated,
no, it isn't.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: duc hiep ha
Date:
Subject: Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Next
From: Joseph Kennedy
Date:
Subject: PostgreSQL 12 reindex