Regarding: Is there a pragma to disable triggers on the sqlite database? Hello Marton,
There's no such pragma to my knowledge. See http://www.sqlite.org/pragma.html Perhaps you can use the command line utility "sqlite3" to ".dump" the schema of your database, isolate just the CREATE TRIGGER commands, and call this file "addTriggers.sql" Then grep that file for just the CREATE TRIGGER first lines, and edit these down to a "dropTriggers.sql" file. Now the sqlite3 ".read" command will allow you to quickly delete or restore triggers with a simple batch file. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
