2010/6/23 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
> it is confusing to me, because I thought triggers are firring BEFORE
> anything goes away. So I assume that all data is still going to be
> visible to the trigger, as it is firing BEFORE. The only thing is, it
> looks like the FKs are doing the deletion and than things are handed
> over to triggers.
>
The trigger is on fooa though, not foob. foob's deletions occur
before cascading to fooa, and only then does the function trigger.
I still think tranaction isolation level should come into this somewhere.
Thom