Disabling Trigger - Mailing list pgsql-novice

From Prasad dev
Subject Disabling Trigger
Date
Msg-id BAY103-F1160240EA36772701E966AC0AE0@phx.gbl
Whole thread Raw
Responses Re: Disabling Trigger
List pgsql-novice
Hello All,

Does any one know how disable a specific trigger i know the following way to
disable trigger but it disables system generated default triggers too.

UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid
='table_name'::pg_catalog.regclass;

I also tried the following

UPDATE pg_trigger SET tgenabled = FALSE where tgname='trigger_name';

But this too doesnt work.

Any help appreciated.

Cheers
Prasad.



pgsql-novice by date:

Previous
From:
Date:
Subject: triggers: how to check if a field changed?
Next
From: Michael Fuhr
Date:
Subject: Re: Fwd: Re: question - plpgsql and query on table given by variable