Will trigger executes even my insert sql fails?!! [message #23400] |
Thu, 05 December 2002 06:11 |
Ramki
Messages: 26 Registered: September 2002
|
Junior Member |
|
|
hi all,
I am having trigger to insert in to some log table.
this trigger seems to be executing even
my main table insert fails due to constraint.
how can I block the execution of this triggered
when my insert on main table is failed.
-Thanks
|
|
|
Re: Will trigger executes even my insert sql fails?!! [message #23402 is a reply to message #23400] |
Thu, 05 December 2002 10:29 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Any DML performed in the trigger will rollback if the transaction fails. However, in your case, there is no way the trigger even fires if the INSERT failed due to a constraint, unless the constraint was DEFERRED. Even then, the entry in the log table would rollback as soon as you commit.
|
|
|