Horton

Re: Triggers and transactions

Rosser Schwarz <rosser.schwarz@gmail.com>

View thread View on postgr.es
From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Craig James <cjames@emolecules.com>
Cc: postgres performance <pgsql-performance@postgresql.org>
Date: 2013-01-28T19:25:18Z
Lists: 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