Hi, I'm working with triggers in Derby and their order of execution is described in the document as given below. However, I wanted to clarify whether triggers are blocking e.g. if an AFTER trigger fires a function, does it block until the function has finished running?
Order of execution When a database event occurs that fires a trigger, Derby performs actions in this order: It fires No Cascade Before triggers. It performs constraint checking (primary key, unique key, foreign key, check). It performs the insert, update, or delete. It fires After triggers. When multiple triggers are defined for the same database event for the same table for the same trigger time (before or after), triggers are fired in the order in which they were created. -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
