Re: Changes to not deferred FK in 8.0.3 to 7.4? - Mailing list pgsql-general

From Tom Lane
Subject Re: Changes to not deferred FK in 8.0.3 to 7.4?
Date
Msg-id 3350.1121698580@sss.pgh.pa.us
Whole thread Raw
In response to Re: Changes to not deferred FK in 8.0.3 to 7.4?  (Janning Vygen <vygen@gmx.de>)
Responses Re: Changes to not deferred FK in 8.0.3 to 7.4?
List pgsql-general
Janning Vygen <vygen@gmx.de> writes:
> But why doesn't it work if i make alle FK deferrable initially deferred?

You didn't do it right --- I don't believe the code actually looks at
pg_constraint, it looks at pg_trigger.  And if you are going to hack
pg_trigger directly, be careful to only change the check-trigger rows
not the action-trigger rows.  I forget which is which but Stephen
probably remembers.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changes to not deferred FK in 8.0.3 to 7.4?
Next
From: Dawid Kuroczko
Date:
Subject: Re: How to create unique constraint on NULL columns