Home > mailing lists

Re: Triggers and transactions - Mailing list pgsql-performance

From	Rosser Schwarz
Subject	Re: Triggers and transactions
Date	January 28, 2013 22:25:22
Msg-id	CAFnxYwhfo-EGDheyyNSEGZM7Pt6ewrktoN-Sw29c_-3aS=s0CA@mail.gmail.com Whole thread Raw
In response to	Triggers and transactions (Craig James <cjames@emolecules.com>)
List	pgsql-performance

On Mon, Jan 28, 2013 at 10:54 AM, Craig James <cjames@emolecules.com> wrote:

But if the drop-and-restore-trigger operation blocks all access to the tables, that's a problem.

Were the triggers in question created with "CREATE CONSTRAINT TRIGGER"? If not, "ALTER TABLE foo DISABLE TRIGGER USER" may do what you need here.

rls

--
:wq

From: Richard Huxton
Date: 28 January 2013, 22:10:50
Subject: Re: Triggers and transactions

From: Alex Vinnik
Date: 29 January 2013, 02:43:58
Subject: Re: Simple join doesn't use index