On 2007-04-15, Tom Lane <[EMAIL PROTECTED]> wrote: > cluster <[EMAIL PROTECTED]> writes: >> It seems that the FK triggers for the table are evaluated even though >> none of the FK columns are altered. > > Hm, they're not supposed to be, at least not in reasonably modern > PG releases (and one that breaks out trigger runtime in EXPLAIN ANALYZE > should be modern enough IIRC). Exactly which PG release are you > running? Can you provide a self-contained test case?
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. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
