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