Re: [BUGS] Combination of Triggers and self-FKs produces inconsistent data

[Josh Berkus]

Tom Lane wrote:
Josh Berkus <j...@agliodbs.com> writes:
Summary: self-referential FKs are not enforced properly in the
        presence of BEFORE triggers

This isn't a bug.  If you create triggers that prevent the RI actions
from being taken, it's your own problem.

Huh?  Since when was it OK by us to have data which violates a declared 
FK under *any* circumstances?  Where in our docs does it say that 
Foreign Keys are not enforced if the table has triggers on it?

--Josh

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs