I cannot find right now details on this in SQLite documentation but AFAIK order of triggers execution is undefined and you cannot rely on any of them.
Pavel On Mon, Feb 22, 2010 at 3:15 PM, Jens Frøkjær <j...@frokjaer.net> wrote: > Hi, > > I was wondering in what order triggers are executed. I'm using the after > update, and have both "column-based" and "row-based" triggers. By > column-based, i simply mean triggers that only fire if a specific column is > updated. > > I did a bit of googling myself, and came up with [1]. It is pretty clear, > triggers should be executed alphabetically. That actually seemes like a > great idea, because, then I have full control. I also did my own testing, > which turned up reverse-creating ordering. That means, the newest created > trigger is called first. > > Is the order actually fixed, or can it be "any order"? And if it is fixed, > can I, to some degree, trust that it will not change in future relases? > > [1]: http://code.google.com/p/sqlite-fk-triggers/wiki/TriggerOrder > > Best regards, > Jens F! > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
