Re: trigger question.

From: "Shridhar Daithankar<shridhar_daithankar(at)nospam(dot)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: trigger question.
Date: 2003-03-25 16:16:27
Message-ID: 200303252146.27592.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 25 Mar 2003 9:31 pm, alain(dot)bruneau(at)acoss(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laszlo Hornyak 2003-03-25 16:17:09 Re: PL/Java
Previous Message Fabio Furia Silva 2003-03-25 16:12:00 Persistent variables between cross-calls in C functions