Re: Deferrable FK not behaving as expected.

[Thomas Kellerer <shammat@xxxxxxx>]

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