ENABLE / DISABLE ALL TRIGGERS IN DATABASE

Поиск
Список
Период
Сортировка
От Teemu Juntunen
Тема ENABLE / DISABLE ALL TRIGGERS IN DATABASE
Дата
Msg-id 97917F88650A4CF09BD8BF9562F3024E@eng02
обсуждение исходный текст
Ответы Re: ENABLE / DISABLE ALL TRIGGERS IN DATABASE  (Terry Lee Tucker <terry@chosen-ones.org>)
Re: ENABLE / DISABLE ALL TRIGGERS IN DATABASE  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Postgre connect on Postgre
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: update and group by/aggregate