Disabling Trigger

From: "Prasad dev" <esteem3300(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Disabling Trigger
Date: 2005-08-30 03:00:30
Message-ID: BAY103-F1160240EA36772701E966AC0AE0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-08-30 03:17:48 Re: Fwd: Re: question - plpgsql and query on table given by variable
Previous Message me 2005-08-30 00:46:58 triggers: how to check if a field changed?