Postgres Pro
Downloads
Home   >   mailing lists

Re: Deferrable FK not behaving as expected. - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Deferrable FK not behaving as expected.
Date
Msg-id b97cbd9d-1615-c9e1-aff1-683a37fedee9@gmx.net
Whole thread Raw
In response to Deferrable FK not behaving as expected.  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Deferrable FK not behaving as expected.
Re: Deferrable FK not behaving as expected.
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Deferrable FK not behaving as expected.
Next
From: Ron
Date:
Subject: Re: Deferrable FK not behaving as expected.