Re: How to tell if a trigger is disabled

From: "Ian Harding" <harding(dot)ian(at)gmail(dot)com>
To: "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to tell if a trigger is disabled
Date: 2008-08-16 18:22:25
Message-ID: 725602300808161122x4ded0e55g4ff88fd7a5043872@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Ian Harding" <harding(dot)ian(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Decibel! 2008-08-16 19:28:37 Re: Confronting the maximum column limitation
Previous Message Scott Marlowe 2008-08-16 09:28:43 Re: What's size of your PostgreSQL Database?