On 03/05/2013 09:59 PM, Jay A. Kreibich wrote:
On Tue, Mar 05, 2013 at 11:20:27PM +1100, Philip Warner scratched on the wall:
On 5/03/2013 9:53 PM, Richard Hipp wrote:
Recursive triggers (triggers that invoke themselves either directly or
indirectly) were added in version 3.6.18, 2009-09-11.
These are not strictly recursive; the 'when' clause means that trigger 1
will cause trigger 2 to be called etc.
In this case, it is any trigger that invokes any other trigger.
Prior to 3.6.18 there was no trigger "stack" and triggers could be
only one layer deep.
I think that should have worked though. Trigger 1 should have been able
to invoke trigger 2. However, trigger 2 could not then invoke trigger 1.
So you could say that there was a kind of stack, but no single trigger
could appear within it more than once.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
