Re: Deferrable FK not behaving as expected.

[Thomas Kellerer]

Ron schrieb am 07.12.2020 um 19:15:

Referenced by:
     TABLE "sales_detail" CONSTRAINT "fk_sales_detail_sales_header"
           FOREIGN KEY (cust_id, order_ts) REFERENCES sales_header(cust_id, 
order_ts) *DEFERRABLE*

I think if you only mention "deferrable" this is the same as "deferrable initially 
immediate",
so you will need to make them deferrable in your transaction:

    SET CONSTRAINTS ALL DEFERRED;

or create the constraint with

    deferrable initially deferred

Thomas