Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 Jan 2007 15:24:34 -0500
"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
- Follow-Ups:
- Re: RI checks during UPDATEs
- From: Simon Riggs
- Re: RI checks during UPDATEs
- References:
- RI checks during UPDATEs
- From: Simon Riggs
- RI checks during UPDATEs
- Prev by Date: Re: [pgsql-patches] pg_dump pretty_print
- Next by Date: Re: [DOCS] "May", "can", "might"
- Previous by thread: RI checks during UPDATEs
- Next by thread: Re: RI checks during UPDATEs
- Indexes: