"Simon Chen" <[email protected]> wrote in message news:[email protected] > I guess if the trigger contains database operations, they would be > rolled-back as well. > The question is, if the trigger externalizes some internal state, how > can a rollback revoke that?
It can't of course. At this point, it's your problem, not SQLite's. > A stupid example would be, a trigger sends out an email saying "a > inserted", but this transaction actually fails. The email recipient > then is in a wrong state... So, don't do that. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
