Re: BUG #4992: "BEFORE DELETE" trigger puts the database in an inconsistent state

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stratsimir Kolchevski" <stratsimir(at)bastun(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4992: "BEFORE DELETE" trigger puts the database in an inconsistent state
Date: 2009-08-18 14:03:34
Message-ID: 7060.1250604214@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Stratsimir Kolchevski" <stratsimir(at)bastun(dot)net> writes:
> [ BEFORE DELETE triggers can suppress foreign key updates too ]

This is not a bug, it's operating as designed. If we didn't do that
it would foreclose many useful applications of triggers.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Saito 2009-08-18 14:24:32 Re: BUG #4991: problem with ODBC driver 8.4
Previous Message Morus Walter 2009-08-18 12:47:53 BUG #4993: memory issue with array_agg