Re: [GENERAL] How to tell if a trigger is disabled

2008-08-16 Thread Ian Harding
On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Ian Harding" <[EMAIL PROTECTED]> 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 m

Re: [GENERAL] How to tell if a trigger is disabled

2008-08-15 Thread Tom Lane
"Ian Harding" <[EMAIL PROTECTED]> 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

[GENERAL] How to tell if a trigger is disabled

2008-08-15 Thread Ian Harding
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 -