Re: Combination of Triggers and self-FKs produces inconsistent data - Mailing list pgsql-bugs

From Gregory Stark
Subject Re: Combination of Triggers and self-FKs produces inconsistent data
Date
Msg-id 87ljsuqrrg.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Combination of Triggers and self-FKs produces inconsistent data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> writes:

> It doesn't say that, because it isn't true.  What is true is that if you
> make a trigger that prevents updates from happening, it breaks RI
> updates as well as directly-user-initiated updates.

Can we detect that this happened and throw an error? I suspect not, though,
since we have no way to actually determine whether the user trigger didn't do
something else equivalent.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Combination of Triggers and self-FKs produces inconsistent data
Next
From: Josh Berkus
Date:
Subject: Re: Combination of Triggers and self-FKs produces inconsistent data