"Tim Leppard" <hbug_1(at)hotmail(dot)com> writes:
> Returning NULL from a BEFORE DELETE trigger function on a referencing table
> using CASCADE allows you to break RI.
Yup, so don't do that ;-). Actually there are any number of ways to
break an RI constraint with poorly designed triggers. The only way
we could prevent it is to make RI updates not fire triggers, which seems
a cure worse than the disease.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Simon Riggs||Date: 2008-09-25 18:50:39|
|Subject: Re: [ADMIN] Postgres Stats after Crash Recovery|
|Previous:||From: Tom Lane||Date: 2008-09-25 16:22:31|
|Subject: Re: Incorrect "invalid AM/PM string" error from to_timestamp |