Re: Delete Order When Referential Integrity Is Active

----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
Sent: Tuesday, November 26, 2002 4:23 AM


> the behavior you're looking for.  I haven't really looked to see if
> there's anything in the spec about the timing of dependent deletes as
> associated with triggers, though.


There is something in the docs about tuple visibility that states, "if a
query affects a row, each query in time after this one, no matter if it's
triggered by the original query or it's an independent query, sees the new
state of the tuple" or something like that.

Doesn't it apply to this case? I mean, reference is effectively a trigger,
something like

... AFTER DELETE ON MasterTable FROM DetailTable ...

so the DELETE's on DetailTable _must_ follow (in time) the DELETE on
MasterTable. Maybe it's the exact cause that the master row is deleted
first.

Gurus, please teach me something and tell me if my thoughts are right or not
:)

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------