Thread: Support for Deferred Constraints in PG15 Logical Replication

Support for Deferred Constraints in PG15 Logical Replication

From
Jitesh Srivastava
Date:
Hello hiveminds,

I'm interested in finding out whether logical replication in PostgreSQL 15 includes support for deferrable unique constraints.


Regards, 
Jitesh Srivastava

Re: Support for Deferred Constraints in PG15 Logical Replication

From
Laurenz Albe
Date:
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