On Sun, Nov 16, 2008 at 12:39 PM, Peter Billen <peter(at)clueless(dot)be> 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 it's disabled
> in transaction T1?
>
yes, but this will lock table operations in other transactions that would
otherwise use that trigger. So be careful with it.