How to tell if a trigger is disabled

Поиск
Список
Период
Сортировка
От Ian Harding
Тема How to tell if a trigger is disabled
Дата
Msg-id 725602300808151635v477807dfqb8b1e1a3b35a87da@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to tell if a trigger is disabled  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Is there any way to tell if a trigger or triggers are disabled on a
table?  I was updating some data a week or two ago and must have
forgotten to re-enable the triggers.  Took me a little while to figure
out.  \d tablename didn't tell me, nor did \d+ tablename.

This is on 8.2.3.

Thanks,

- Ian

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

Предыдущее
От: Christophe
Дата:
Сообщение: Re: plpgsql functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to tell if a trigger is disabled