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
