As a follow up, I would read the trigger into a file first, so that you can
restore it. Also, watch single quotes and the semicolon at the end of the
trigger definition. It may not show up correctly in the structure readout of the
trigger.
And, you don't need to drop the functions that the trigger references, just the
trigger.
Shridhar Daithankar wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>