On Fri, 12 Nov 2004, Thomas Berg wrote: > Within a function (and therefore within a transaction), if I UPDATE the > primary key of a table, the old value remains visible in the child table > through the end of the function. Is this
8.0 runs immediate triggers after each statement of a function and also forces referential actions to be treated as immediate and as such should change the behavior mentioned. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])