Re: PostgreSQL 7.4.2 allows foreign key violation

On Fri, 6 Aug 2004, Tom Lane wrote:

> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
> > It also looks like before triggers returning NULL can break them.
>
> Or a BEFORE trigger that overrides the attempted field update.
>
> > I think we'd been worried about the added cost of doing the check when
> > the average case doesn't have this problem but we should probably just
> > eat it. In practice I think it's one line of code per action function
> > (on update set default already does it).
>
> Already does what? I see nothing in there that would override either
> triggers or rules...

It's not for overriding the triggers or rules, but instead checking that
the post action state is valid (by running the no action code which
makes sure that either another row now has the pk value or that there are
no longer any matching rows).