"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
In response to
pgsql-novice by date
|Next:||From: Jaromír Kamler||Date: 2005-08-30 06:30:29|
|Subject: Fwd: Re: Fwd: Re: question - plpgsql and query on table given by variable|
|Previous:||From: Lance Arlaus||Date: 2005-08-30 04:25:36|
|Subject: Re: triggers: how to check if a field changed?|