It is not possible to remove the "test1_t1_key" constraint because the "test2_t1_fkey" internally references it: <<< postgres=# ALTER TABLE test1 DROP CONSTRAINT test1_t1_key; ERROR: cannot drop constraint test1_t1_key on table test1 because other objects depend on it DETAIL: constraint test2_t1_fkey on table test2 depends on index test1_t1_key HINT: Use DROP ... CASCADE to drop the dependent objects too. >>>
Is there a solution to" alter" the "test2_t1_fkey" constraint so that it uses the "primary key constraint", then to remove the unnecessary unique constraint on table test1
The following solution works but causes me deadlocks problems with BDR: <<< ALTER TABLE test2 DROP CONSTRAINT test2_t1_fkey; ALTER TABLE test1 DROP CONSTRAINT test1_t1_key; ALTER TABLE test2 ADD CONSTRAINT test2_t1_fkey FOREIGN KEY (t1) REFERENCES test1(t1); >>>