Postgres Pro
Downloads
Home   >   mailing lists

Re: trigger question. - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: trigger question.
Date
Msg-id 200303252146.27592.shridhar_daithankar@nospam.persistent.co.in
Whole thread Raw
In response to trigger question.  (alain.bruneau@acoss.fr)
Responses Re: trigger question.  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: alain.bruneau@acoss.fr
Date:
Subject: trigger question.
Next
From: Stephan Szabo
Date:
Subject: Re: '' <> NULL