Horton

Re: trigger question.

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

View thread View on postgr.es
From: "Shridhar Daithankar<shridhar_daithankar@nospam.persistent.co.in>" <shridhar_daithankar@persistent.co.in>
To: pgsql-general@postgresql.org
Date: 2003-03-25T16:16:27Z
Lists: pgsql-general 
On Tuesday 25 Mar 2003 9:31 pm, alain.bruneau@acoss.fr wrote:
> I have a problem with trigger. I don't find a way to disable it.
> Oracle statement :
> ALTER TRIGGER "TRG_DT_ACTI"  ENABLE
> or
> ALTER TRIGGER "TRG_DT_ACTI"  DISABLE
> I am looking for a way to do the same thing with postgresql.
>
> I want to disable trigger before COPY and enable it after.
> How can I do that?

Drop and recreate respectively.

HTH

 Shridhar