Re: [GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE

2008-08-27 Thread Albe Laurenz
Teemu Juntunen wrote: > I think this has been asked before, but I can't find the > answer from arcive nor google. How to disable/enable all the > riggers in a database? I have problem with disabled triggers > after database restore. If there is no simple way, could this > be made in a function

Re: [GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE

2008-08-27 Thread Terry Lee Tucker
On Wednesday 27 August 2008 04:24, Teemu Juntunen wrote: > Hi, > > I think this has been asked before, but I can't find the answer from arcive > nor google. How to disable/enable all the riggers in a database? I have > problem with disabled triggers after database restore. If there is no > simple w

Re: [GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE

2008-08-27 Thread Teemu Juntunen
- From: Teemu Juntunen To: PostgreSQL Sent: Wednesday, August 27, 2008 11:24 AM Subject: [GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE Hi, I think this has been asked before, but I can't find the answer from arcive nor google. How to disable/enable all the riggers in a dat

[GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE

2008-08-27 Thread Teemu Juntunen
Hi, I think this has been asked before, but I can't find the answer from arcive nor google. How to disable/enable all the riggers in a database? I have problem with disabled triggers after database restore. If there is no simple way, could this be made in a function where you find the table nam