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
Дата: