Postgres Pro
Downloads
Home   >   mailing lists

How to tell if a trigger is disabled - Mailing list pgsql-general

From Ian Harding
Subject How to tell if a trigger is disabled
Date
Msg-id 725602300808151635v477807dfqb8b1e1a3b35a87da@mail.gmail.com
Whole thread Raw
Responses Re: How to tell if a trigger is disabled  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Christophe
Date:
Subject: Re: plpgsql functions
Next
From: Tom Lane
Date:
Subject: Re: How to tell if a trigger is disabled