[GENERAL] Disable triggers per transaction 8.2.3

2007-10-10 Thread Henrik
Hello list, I wonder if it is possible to disable triggers for a single transaction. I know I can disable triggers per table but then I need to disable all triggers in all recursive tables before doing by query. Can I do: BEGIN TRANSACTION; DISABLE TRIGGERS; DELETE FROM tbl_foo WHERE ID 5;

Re: [GENERAL] Disable triggers per transaction 8.2.3

2007-10-10 Thread Merlin Moncure
On 10/10/07, Henrik [EMAIL PROTECTED] wrote: Hello list, I wonder if it is possible to disable triggers for a single transaction. I know I can disable triggers per table but then I need to disable all triggers in all recursive tables before doing by query. Can I do: BEGIN TRANSACTION;