Re: Disabling triggers on a relation.

by total no of triggers that relation has,
which is got from a subselct on pg_triggers

On Thursday 05 December 2002 10:24 am, shreedhar wrote:
> 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(at)myrealbox(dot)com>
> To: <pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.