On Tue, 2007-01-30 at 15:24 -0500, Tom Lane wrote: > "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.
OK, funny guy. :-) Its not very well documented, is all I can say. The code comments elsewhere in the file are very specific that the code applies to UPDATEs as well as INSERTs, hence my confusion. I'm relieved, actually, but still have a locking problem to resolve. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match