Re: Disabling triggers on a relation.

Hi Bhuvan & Mallah,

Have you checked desabling of triggers. What reltriggers represent. If we
set it as '0' to enable by what value it has to be updated.

Sreedhar
----- Original Message -----
From: "Bhuvan A" <bhuvansql@myrealbox.com>
To: <pgsql-admin@postgresql.org>
Sent: Monday, December 02, 2002 3:16 PM
Subject: Re: [ADMIN] Disabling triggers on a relation.


>
> > What is the correct method of temporarily
> > disabling all triggers from a table?
>
> Disable:
> db=# update pg_class set reltriggers = '0' where relname = 'your_table';
>
> Enable:
> db=# update pg_class set reltriggers = (select count(*) from pg_trigger
> where pg_class.oid = tgrelid) where relname = 'your_table';
>
> >
> >
> > also is there any command/function  to show the
> > trigger defination ? like pg_index_def does for indexes?
> >
>
> Not sure.
>
> regards,
> bhuvaneswaran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>