Enable/Disable triggers

[Josué Maldonado]

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



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Bruce Momjian]

Re: Enable/Disable triggers

Josué Maldonado wrote:[color=blue]
> Hello list,
>
> Is there a way to disable temporary all the triggers of a table or
> database and then enable them back?[/color]

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.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org