On Sep 12, 2009, at 12:01 AM, Simon Slavin wrote: > > On 11 Sep 2009, at 5:45pm, D. Richard Hipp wrote: > >> The second major enhancement is that SQLite now support recursive >> triggers. The older non-recursive behavior of triggers is still the >> default behavior. Recursive triggers are activated using the >> recursive_triggers pragma. In addition to allowing triggers to call >> themselves (either directly or indirectly) the new capability also >> fires DELETE triggers on rows that are removed from a table as a >> result of REPLACE conflict resolution processing. > > May I ask what happens if SQLITE_MAX_TRIGGER_DEPTH is reached ? Is an > error generated ? Is a transaction marked as failed, etc. ?
The statement execution fails with SQLITE_ERROR. The error message says something like "too many levels of trigger recursion". Dan. > > Simon. > _______________________________________________ > 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