| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | cnliou <cnliou(at)so-net(dot)net(dot)tw> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: RI within PLPGSQL |
| Date: | 2003-12-12 16:41:24 |
| Message-ID: | 20031212083845.W69750@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-12-12 17:17:58 | Re: Wierd MD5-authentication crash on Solaris 8 |
| Previous Message | kruti pandya | 2003-12-12 15:03:04 | Re: [albanyiso] 1 Bedroom Apartment Available $550 including Heat & H Water |