dbTalk Databases Forums  

Enable/Disable triggers

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Enable/Disable triggers in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Josué Maldonado
 
Posts: n/a

Default Enable/Disable triggers - 03-04-2004 , 09:43 AM






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


Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: Enable/Disable triggers - 03-04-2004 , 10:33 AM






Josué Maldonado wrote:
Quote:
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 (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.