Thomas Flemming wrote:
> Is there a way in SQLite, to temporary disable and enable a trigger without 
> dropping and recreating ?

You could disable recursive triggers, and then make your triggers
recursive by executing all your SQL statements through a temporary
trigger on some temporary table.  But that would restrict what you could
execute, and be more cumbersome than removing the actual triggers.

What is the actual problem you're trying to solve?  If you have
temporarily inconsistent data, it might be a better idea to deal with it
in a temporary table.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to