"Simon Riggs" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq