On 2007-04-15, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew - Supernews <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
