Re: [sqlite] Re: Re: trigger and new.*

2007-07-12 Thread Charly Caulet
Le mercredi 11 juillet 2007 à 12:47 -0400, Igor Tandetnik a écrit : > Be aware that SQLite never enters infinite loop of triggers. It keeps > track of a chain of nested triggers that led to the currently executing > statement; if that statement would fire a trigger that is already in the > chain

[sqlite] Re: Re: trigger and new.*

2007-07-11 Thread Igor Tandetnik
Charly Caulet <[EMAIL PROTECTED]> wrote: I mean that I had a trigger on "INSERT" that executes an update, and I had some triggers on "UPDATE" that executes any other updates... So it was an infernal loop. Be aware that SQLite never enters infinite loop of triggers. It keeps track of a chain o