On Sun, Nov 16, 2008 at 12:39 PM, Peter Billen
<peter@clueless.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.