Re: [GENERAL] disable/enable trigger and transaction

2008-11-17 Thread Grzegorz Jaśkiewicz
On Sun, Nov 16, 2008 at 12:39 PM, Peter Billen [EMAIL PROTECTED] wrote: Hi all, Is the instruction 'ALTER TABLE x ENABLE/DISABLE TRIGGER y' part of the current transaction? That is, say that there are two ongoing transactions, T1 and T2. Is the trigger y still enabled in transaction T2 if

[GENERAL] disable/enable trigger and transaction

2008-11-16 Thread Peter Billen
Hi all, Is the instruction 'ALTER TABLE x ENABLE/DISABLE TRIGGER y' part of the current transaction? That is, say that there are two ongoing transactions, T1 and T2. Is the trigger y still enabled in transaction T2 if it's disabled in transaction T1? Thanks in advance. Kind regards, Peter