Kodok Márton wrote:
> 
>   I am working on a syncing project and I do have a lot of triggers to 
> read/write foreign keys.
>   And while I do the sync of one table the triggers are causing a strange 
> effect (as the other table is not yet synced).
>   Is there a pragma to disable triggers on the sqlite database?
> 

No, there is no way to disable triggers.

You could save the SQL used to create the triggers from the 
sqlite_master table, drop the triggers, do the updates, and then finally 
use the saved SQL to recreate the triggers after the updates.

HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to