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

Re: RI checks during UPDATEs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RI checks during UPDATEs
Date: 2007-01-30 20:24:34
Message-ID: 9174.1170188674@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Simon Riggs" <simon(at)2ndquadrant(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Guillaume LelargeDate: 2007-01-30 20:35:27
Subject: Re: "May", "can", "might"
Previous:From: TimasmithDate: 2007-01-30 20:17:19
Subject: Re: SQL to get a table columns comments?

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