2010/6/23 Grzegorz Jaśkiewicz <[email protected]>: > 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
