Thread: How to tell if a trigger is disabled

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

"Ian Harding" <harding.ian@gmail.com> writes:
> 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.

FWIW, 8.3's psql knows about showing this in \dt.

            regards, tom lane

On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Ian Harding" <harding.ian@gmail.com> writes:
>> 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.
>
> FWIW, 8.3's psql knows about showing this in \dt.
>
Yet another reason to upgrade.. Thanks!

- Ian