Re: BUG #6531: integrity constraint failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: claudiomsi(at)hotmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6531: integrity constraint failure
Date: 2012-03-14 16:20:58
Message-ID: 1844.1331742058@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

claudiomsi(at)hotmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Rikard Pavelic 2012-03-14 18:19:14 Re: BUG #6489: Alter table with composite type/table
Previous Message claudiomsi 2012-03-14 16:07:00 BUG #6531: integrity constraint failure