Skip site navigation (1) Skip section navigation (2)

Re: FK triggers misused?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: andrew(at)supernews(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: FK triggers misused?
Date: 2007-04-15 15:22:43
Message-ID: 102.1176650563@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Andrew - SupernewsDate: 2007-04-15 22:06:59
Subject: Re: FK triggers misused?
Previous:From: SteveDate: 2007-04-15 08:13:53
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group