Sample Header Ad - 728x90

How to use exclusion constraints with Postgres BDR

0 votes
0 answers
127 views
Looks like BDR doesn't support exclusion constraints ... However, I'm using exclusion constraints to achieve the same result as a unique constraint (but using a hash index instead of a B-Tree): alter table my_table add constraint my_table_unique_hash exclude using hash (my_unique_field with =); Can I tell BDR to consider the exclusion constraint only for the master and ignore it in the read replicas?
Asked by Elifarley (101 rep)
Apr 4, 2022, 10:59 AM