Thread: Enable/Disable triggers

Enable/Disable triggers

From
Josué Maldonado
Date:
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



Re: Enable/Disable triggers

From
Bruce Momjian
Date:
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