Hello folks,
I have a table (table 1) with a trigger (trigger 1) which is invoked
after INSERT, UPDATE or DELETE. Then I have another table (table 2),
with a trigger (trigger 2) that updates the table 1 ON UPDATE.
The problem is that trigger 1 is never invoked when trigger 2 updates
table 1. This leads to an error later in trigger 2, since the database
is in a bad state. I can check, trough SELECTs in trigger 2, that table
1 *is* actually updated, but still, the trigger is never called.
The only cause I can think of is that AFTER UPDATE means "at the end of
the transaction". Is that a correct assumption? Is there anything to do
about it?
Regards
Erik
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/