Simon Chen <[email protected]> wrote: > A simple question... Say I have a bunch of db insert/updates > performed as a transaction. If the table has a "AFTER INSERT" > trigger, is it fired: 1) right after the insert statement? > 2) right before transaction commit? > 3) after commit?
Running trigger is an integral part of executing a statement. I guess #1 is closest. > And what if the transaction fails if 1) or 2) is the case? Then it's rolled back. This is unrelated to whether there are any triggers. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
