Ron <ronljohnsonjr@xxxxxxxxx> writes: > Neither technique worked. > test=# ALTER TABLE sales_detail ALTER CONSTRAINT > fk_sales_detail_sales_header DEFERRABLE INITIALLY DEFERRED; > ALTER TABLE Hmm, reproduced here. There seems to be some kind of bug in ALTER CONSTRAINT --- it looks like it's updated all the child FKs successfully, but it actually hasn't. If you drop the FK constraint altogether, and recreate it having DEFERRABLE INITIALLY DEFERRED from the start, it should work --- at least it does for me. regards, tom lane
