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

Reply via email to