If I insert duplicate rows, I assume the order of operations is:
Before triggers
Insert
Exception
After triggers -- never executed
If I insert duplicate rows, I assume the order of operations is:
Before triggers
Insert
Exception
After triggers -- never executed
Correct.
This can be easily checked with the Trace API. The execution order of
the trace events are:
EXECUTE_STATEMENT_START (insert into)
-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Sent: Thursday, January 10, 2013 2:03 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Unique key exceptions triggers
If I insert duplicate rows, I assume the order of operations is:
Before triggers
Insert
Exception