Andrew - Supernews <andrew+nonews(at)supernews(dot)com> writes:
> Looking at current CVS code the RI check seems to be skipped on update of
> the _referred to_ table if the old and new values match, but not on update
> of the _referring_ table.
No, both sides are supposed to be tested, see lines 3350-3395 in
src/backend/commands/trigger.c. Or do you see something broken there?
It works for me in a quick test.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Andrew - Supernews||Date: 2007-04-15 22:06:59|
|Subject: Re: FK triggers misused?|
|Previous:||From: Steve||Date: 2007-04-15 08:13:53|
|Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely
Variable Query Performance) |