On 2007-04-15, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > cluster <skrald@xxxxxxxxxx> 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
