Re: RI within PLPGSQL - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: RI within PLPGSQL
Date
Msg-id 20031212083845.W69750@megazone.bigpanda.com
Whole thread Raw
In response to RI within PLPGSQL  ("cnliou" <cnliou@so-net.net.tw>)
List pgsql-bugs
On Fri, 12 Dec 2003, cnliou wrote:

> It looks to me a referential integrity problem (only?)
> within PLPGSQL. Plesase see the test result below.

There have been discussions in the past about when cascade events
should occur.  The code currently does what I believe was last
agreed upon, although its behavior is fairly wierd for deferred
constraints and functions.  Right now the cascade happens at the
end of the full statement (in this case the call to the function)
which is why you get a key constraint error in the second call to f1
and why the later inserted row is removed in f2.

pgsql-bugs by date:

Previous
From: "cnliou"
Date:
Subject: RI within PLPGSQL
Next
From: Josh Berkus
Date:
Subject: Re: Wierd MD5-authentication crash on Solaris 8