Triggers With Transactions

[chris gutierrez]

Hello!

This may or may not be a silly question...

is it possible to use triggers along side transactions and still have the triggered queries reap the benefits of the transaction?

I suppose an example would be...

/* start a transaction */
BEGIN
INSERT INTO sometable (col1,col2) VALUES (val1,val2);
INSERT INTO sometable2 (col1,col2) VALUES (val1,val2);
COMMIT

now lets say that the second insert statement fails, hence causing the transaction to fail.

if 'sometable' has a BEFORE INSERT or AFTER INSERT trigger on it, should that action, be it another insert or update, even a delete, get rolled back along with the rest of the transaction?