On Thu, 8 Dec 2005, Jan Wieck wrote: > On 12/7/2005 4:50 PM, Stephan Szabo wrote: > > > On Wed, 7 Dec 2005, Bruce Momjian wrote: > > > >> I had an open 8.1 item that was: > >> > >> o fix foreign trigger timing issue > >> > >> Would someone supply text for a TODO entry on this, as I don't think we > >> fixed it in 8.1. > > > > I'd split this into two separate items now. > > > > Fix before delete triggers on cascaded deletes to run after the cascaded > > delete is done. This is odd, but seems to be what the spec requires. > > Ugh, that sounds ugly.
Yeah. I really don't understand it, but it appears to me to be explicitly different in the spec for on delete cascade even compared to the rest of the referential actions. > One problem I see is, what do we do if the BEFORE > trigger then returns NULL (to skip the delete). The cascaded operations > are already done. Do we have to execute the cascaded deletes in a > subtransaction or do we disallow the skip in this case? I think we'd have disallow skipping. Especially since skipping would probably end up with a violated constraint. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings