Re: Foreign Key Deferrable Misunderstanding or Bug? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Foreign Key Deferrable Misunderstanding or Bug?
Date
Msg-id 20090806144542.Y96899@megazone.bigpanda.com
Whole thread Raw
In response to Foreign Key Deferrable Misunderstanding or Bug?  (Paul Rogers <progers@sparkbase.com>)
List pgsql-general
On Thu, 6 Aug 2009, Paul Rogers wrote:

> Why does the attached script fail with a foreign key constraint violation?

Referential actions are not deferred when a constraint is marked
deferrable (as that appears to be what the spec wants), so ON DELETE
RESTRICT will still fail on the statement, while ON DELETE NO ACTION (ie,
only check at constraint check time) should wait to the end.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Foreign Key Deferrable Misunderstanding or Bug?
Next
From: Josh Trutwin
Date:
Subject: Re: Empty Updates, ON UPDATE triggers and Rules