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 TRANSACT

[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;