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?