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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 [EMAIL PROTECTED]) > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster