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