disabling triggers - Mailing list pgsql-sql

From
Subject disabling triggers
Date
Msg-id 1164.219.65.230.103.1055871254.squirrel@mail.trade-india.com
Whole thread Raw
Responses Re: disabling triggers
List pgsql-sql
Hi,

Is setting reltriggers=0 on pg_class an  accepatble way of
disabling triggers on a table temporarily?

secondly is it worth having commands like
alter trigger <triggername> inactive;
alter trigger <triggername> active ;
i feel such commands exists on Oracle.

sometime we need to bulk update tables from backdoor
and we feel the trigger execution to be unneccessary.


regds
mallah.


-----------------------------------------
Get your free web based email at trade-india.com.  "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/




pgsql-sql by date:

Previous
From: Guillaume LELARGE
Date:
Subject: Re: CREATE table1 FROM table2
Next
From: Josh Berkus
Date:
Subject: Re: disabling triggers