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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend