On 12/7/20 1:15 PM, Ron wrote:
> On 12/7/20 1:27 PM, Tom Lane wrote:
>> Ron <ronljohnsonjr@gmail.com> 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 ---
>
> Do I need to file a bug report?
No:
https://www.postgresql.org/message-id/3144850.1607369633%40sss.pgh.pa.us
>
>> 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.
>
> That worked.
>
--
Adrian Klaver
adrian.klaver@aklaver.com