Re: Disabling Trigger

"Prasad dev" <esteem3300(at)hotmail(dot)com> writes:
> 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.

FWIW, PG 8.1 will have a supported command for that.

> I also tried the following
> UPDATE pg_trigger SET tgenabled = FALSE where tgname='trigger_name';
> But this too doesnt work.

That should work in recent releases, though you do have an issue of
whether backends will notice it right away. A dummy update on the
pg_class row is the best way around that problem AFAIK.

What PG version are you using, and what exactly does "not work" mean?

regards, tom lane