Support for Deferred Constraints in PG15 Logical Replication
Started by Jitesh Srivastavaover 2 years ago2 messagesgeneral
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
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