Re: RI checks during UPDATEs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RI checks during UPDATEs
Date
Msg-id 9174.1170188674@sss.pgh.pa.us
Whole thread Raw
In response to RI checks during UPDATEs  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: RI checks during UPDATEs  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> Any objections to implementing this?

Only that it was done a long time ago --- see
RI_FKey_keyequal_upd_pk/fk.

> It would be even better if there was some way of not executing the
> trigger at all if we knew that the UPDATE statement doesn't SET the FK
> columns.

People keep suggesting that, and the counterexample is always that you
can't know what a BEFORE trigger might do to the row.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: [pgsql-patches] pg_dump pretty_print
Next
From: Guillaume Lelarge
Date:
Subject: Re: [DOCS] "May", "can", "might"