On 2007-04-15, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Andrew - Supernews <andrew+nonews@xxxxxxxxxxxxx> 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. Hm, you're right; I was looking at the logic in the triggers themselves (in ri_triggers.c). So the next question is, what pg version is the original poster using? because 8.1.x doesn't report trigger execution times, and 8.2.x would use a single bitmap index scan with an = ANY condition, not a BitmapOr. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services
