Re: FK triggers misused? - Mailing list pgsql-performance

From Tom Lane
Subject Re: FK triggers misused?
Date
Msg-id 102.1176650563@sss.pgh.pa.us
Whole thread Raw
In response to Re: FK triggers misused?  (Andrew - Supernews <andrew+nonews@supernews.com>)
List pgsql-performance
Andrew - Supernews <andrew+nonews@supernews.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

pgsql-performance by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: FK triggers misused?
Next
From: Andrew - Supernews
Date:
Subject: Re: FK triggers misused?