Fredrik Karlsson <dargo...@gmail.com> wrote: > I'm probably doing something really stupid here, but I feel I need to > ask you anyway to see id there is something that I've missed. > Is it not possible for a trigger to trigger itself?
Recursive triggers have to be explicitly turned on: http://sqlite.org/pragma.html#pragma_recursive_triggers > Second question is, of course, can I depend on this behaviour? Or, is > it just because of the version of SQLite I am currently using > (3.6.16)? Recursive triggers are supported beginning with 3.6.18. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users