Re: Changes to not deferred FK in 8.0.3 to 7.4?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Janning Vygen <vygen(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Subject: Re: Changes to not deferred FK in 8.0.3 to 7.4?
Date: 2005-07-18 14:56:20
Message-ID: 3350.1121698580@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Janning Vygen <vygen(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dawid Kuroczko 2005-07-18 15:00:15 Re: How to create unique constraint on NULL columns
Previous Message Greg Patnude 2005-07-18 14:55:38 Re: How to find the number of rows deleted