Disabling Trigger

Поиск
Список
Период
Сортировка
Искать
От
Prasad dev
Тема
Disabling Trigger
Дата
Msg-id
BAY103-F1160240EA36772701E966AC0AE0@phx.gbl
Список
Дерево обсуждения
Disabling Trigger "Prasad dev" <esteem3300@hotmail.com>
Re: Disabling Trigger Tom Lane <tgl@sss.pgh.pa.us>
Re: Disabling Trigger "Prasad dev" <esteem3300@hotmail.com>
Re: Disabling Trigger Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От:
Дата:
От: Michael Fuhr
Дата:
FAQ