Re: disabling triggers

Mallah,

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

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.

--
-Josh BerkusAglio Database SolutionsSan Francisco