Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Combination of Triggers and self-FKs produces inconsistent data
Date
Msg-id 5696.1233187222@sss.pgh.pa.us
Whole thread Raw
In response to Combination of Triggers and self-FKs produces inconsistent data  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Combination of Triggers and self-FKs produces inconsistent data  (Josh Berkus <josh@agliodbs.com>)
List pgsql-bugs
Tree view 
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.

            regards, tom lane

pgsql-bugs by date:

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