Re: Triggers and transactions

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Craig James <cjames(at)emolecules(dot)com>
Cc: postgres performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Triggers and transactions
Date: 2013-01-28 19:25:18
Message-ID: CAFnxYwhfo-EGDheyyNSEGZM7Pt6ewrktoN-Sw29c_-3aS=s0CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 28, 2013 at 10:54 AM, Craig James <cjames(at)emolecules(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gurjeet Singh 2013-01-28 21:30:51 Re: [PERFORM] pgbench to the MAXINT
Previous Message Richard Huxton 2013-01-28 19:10:44 Re: Triggers and transactions