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 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.