Re: Disability the trigger

On 3/16/06, Tomi NA <hefest(at)gmail(dot)com> wrote:
>
>
> On 3/13/06, Claudio Tognolo <claudio(dot)tognolo(at)gmail(dot)com> wrote:
> >
> > I can disable the Trigger?
> >
>
> I'd like to know how this could be done, as well. What I really need is a
> hold-off-all-triggers-untill-I-tell-you-to command, but
> hey, making a trigger just not fire and vice versa would also be nice. :)
>
> Tomislav
>
You can mark triggers as DEFERRABLE and optionally INITIALLY DEFERRED
which will make them hold off on firing until the end of the
transaction, or you can actually turn off triggers with something like
this.

UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'tablename';

and turn them back on like so

UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where
pg_class.oid = tgrelid) WHERE relname = 'tablename';

Of course, all that is best done inside an explicit transaction.