Subject Re: [firebird-support] Triggers, anything I should know?
Author Ann W. Harrison
sqlsvr wrote:
> I'm using the path enumeration model and nested set model in some of my tables and to maintain integrity, I'm planning to update the paths using a trigger. The trigger would be an insert/delete trigger.
> Is there anything special I should know about triggers in Firebird? If a insert fails on a table for some reason, does the INSERT trigger execute?
> If the trigger query fails, does the insert get rollback?

The trigger is part of the statement that caused it to fire,
and succeeds or is completely undone with the statement. If
a trigger executes statements that cause other triggers to
fire, they too are part of the original statement and succeed
or are undone with it.

Good luck,