Postgres Pro
Downloads
Home   >   mailing lists

disable/enable trigger and transaction - Mailing list pgsql-general

From Peter Billen
Subject disable/enable trigger and transaction
Date
Msg-id 49201477.7020506@clueless.be
Whole thread Raw
In response to Re: Vacuum Full is *hideously* slow!  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: disable/enable trigger and transaction
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: Database access over the Internet...
Next
From: "Taha Ozket"
Date:
Subject: LDAP