Re: [sqlite] Enabling recursive triggers

2006-10-05 Thread drh
George Herson <[EMAIL PROTECTED]> wrote: > > Advice on how to pursue enabling recursion? My C is > rusty. The code generator for triggers will need to be rewritten, probably to generate the trigger processing code as VDBE subroutines rather than in-line code. And then the way that triggers are

[sqlite] Enabling recursive triggers

2006-10-05 Thread George Herson
The 12-message 2005-01-04 discussion with subject "Is there any way to enable recursive triggers?"<1> ends with concerns about infinite recursion causing Sqlite to crash without rollback (example email at bottom). First question: Because all non-SELECT sql always takes place within a transaction<