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. ?

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to