2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
987 stars 153 forks source link

Unique constraints must not be deferrable #438

Open jitesh-co opened 1 year ago

jitesh-co commented 1 year ago

I understand that pglogical currently does not provide support for deferred constraints on unique indexes. I wanted to know the reasoning behind this limitation. Is it possible to inquire about the rationale behind this design choice?

Given that pglogical 3.7 now includes support for deferrable unique constraints, I'm curious if there are any considerations or intentions to incorporate this feature into the open-source version of pglogical in the future.