On 12/7/20 1:27 PM, Tom Lane wrote:
> Ron <ronljohnsonjr(at)gmail(dot)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?
> 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.
--
Angular momentum makes the world go 'round.