Обсуждение: Trigger not invoked on update from trigger

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/