> Mallah,
>
>> Is setting reltriggers=0 on pg_class an accepatble way of
>> disabling triggers on a table temporarily?
Ok , but someone on list was scary few months back.
>
> Yes. pg_dump does this.
>
>> secondly is it worth having commands like
>> alter trigger <triggername> inactive;
>> alter trigger <triggername> active ;
>> i feel such commands exists on Oracle.
>
> No, since DROP TRIGGER ... CREATE TRIGGER does the same thing in Postgres.
Agreed , but there is no easy way to view current trigger defination of
existing triggers before dropping from psql .
One has to go the long way of pg_dump -s -t tabname to view a list.
regds
mallah.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
-----------------------------------------
Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/