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