Re: Support for Deferred Constraints in PG15 Logical Replication

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jitesh Srivastava <jitesh(dot)srivastava(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Support for Deferred Constraints in PG15 Logical Replication
Date: 2023-08-28 11:57:37
Message-ID: 2df60a8f29d4d60ef54e59f7c945f2e5ab0d9a42.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Kennedy 2023-08-28 13:51:22 PostgreSQL 12 reindex
Previous Message duc hiep ha 2023-08-28 10:11:15 Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly