Enable/Disable triggers

Started by Josué Maldonadoabout 22 years ago2 messagesgeneral
Jump to latest
#1Josué Maldonado
josue@lamundial.hn

Hello list,

Is there a way to disable temporary all the triggers of a table or
database and then enable them back?

Thanks in advance

--
Josu� Maldonado

#2Bruce Momjian
bruce@momjian.us
In reply to: Josué Maldonado (#1)
Re: Enable/Disable triggers

Josu��� Maldonado wrote:

Hello list,

Is there a way to disable temporary all the triggers of a table or
database and then enable them back?

See the PostgreSQL cookbook for sample implementation function. You
have to muck with the system tables. This is on the TODO list.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073