ENABLE / DISABLE ALL TRIGGERS IN DATABASE

From: "Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)fi>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: ENABLE / DISABLE ALL TRIGGERS IN DATABASE
Date: 2008-08-27 08:24:17
Message-ID: 97917F88650A4CF09BD8BF9562F3024E@eng02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 names and construct the needed commands in strings. If so, how to get all the tablenames from database?

Best regards and thanks!
Teemu Juntunen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-08-27 08:32:43 update and group by/aggregate
Previous Message Tino Wildenhain 2008-08-27 06:09:28 Re: Postgre connect on Postgre