Martin <hier-bei-mir@gmx.net> writes:
> I am facing the exact same bug when using circular references:
I see no error when I try this example in HEAD. I think possibly you
are hitting a bug we fixed last year:
Author: Tom Lane <tgl@sss.pgh.pa.us>
Branch: master [a522fc3d8] 2016-10-26 17:05:06 -0400
Branch: REL9_6_STABLE Release: REL9_6_2 [445035a6e] 2016-10-26 17:05:06 -0400
Branch: REL9_5_STABLE Release: REL9_5_6 [b53c841e5] 2016-10-26 17:05:06 -0400
Branch: REL9_4_STABLE Release: REL9_4_11 [3a9a8c408] 2016-10-26 17:05:06 -0400
Fix incorrect trigger-property updating in ALTER CONSTRAINT. The code to change the deferrability properties of
aforeign-key constraint updated all the associated triggers to match; but a moment's examination of the code that
createsthose triggers in the first place shows that only some of them should track the constraint's deferrability
properties. This leads to odd failures in subsequent exercise of the foreign key, as the triggers are fired at the
wrongtimes. Fix that, and add a regression test comparing the trigger properties produced by ALTER CONSTRAINT with
those you get by creating the constraint as-intended to begin with. Per report from James Parks. Back-patch to
9.4where this ALTER functionality was introduced. Report:
<CAJ3Xv+jzJ8iNNUcp4RKW8b6Qp1xVAxHwSXVpjBNygjKxcVuE9w@mail.gmail.com>
If you're not running a current minor release, please update.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs