Re: BUG #6531: integrity constraint failure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6531: integrity constraint failure
Date
Msg-id 1844.1331742058@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6531: integrity constraint failure  (claudiomsi@hotmail.com)
List pgsql-bugs
claudiomsi@hotmail.com writes:
> It would be a BUG.

No, this is not a bug.  If you create a trigger that disables deletions
on the referencing table, you should not be surprised that
foreign-key-related deletions don't happen.  Triggers do fire on FK
actions; it would be substantially less useful if they didn't.

            regards, tom lane

pgsql-bugs by date:

Previous
From: claudiomsi@hotmail.com
Date:
Subject: BUG #6531: integrity constraint failure
Next
From: Rikard Pavelic
Date:
Subject: Re: BUG #6489: Alter table with composite type/table