Postgres Pro
Downloads
Home   >   mailing lists

trigger question. - Mailing list pgsql-general

From alain.bruneau@acoss.fr
Subject trigger question.
Date
Msg-id OFE53E6E2C.78FC5E25-ONC1256CF4.005593E8@ac750.recouv
Whole thread Raw
Responses Re: trigger question.  ("Shridhar Daithankar<shridhar_daithankar@nospam.persistent.co.in>" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
Hi.
Has anyone migrated from Oracle to Postgresql there ?

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?

Thank you for your help.

Regards,
Alain.

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: '' <> NULL
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: trigger question.