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

From Josh Berkus
Subject Re: Combination of Triggers and self-FKs produces inconsistent data
Date
Msg-id 4980F27F.108@agliodbs.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 wrote:
> Josh Berkus <josh@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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Combination of Triggers and self-FKs produces inconsistent data
Next
From: Gregory Stark
Date:
Subject: Re: Combination of Triggers and self-FKs produces inconsistent data