Quick Links

trigger question.

From:	alain(dot)bruneau(at)acoss(dot)fr
To:	pgsql-general(at)postgresql(dot)org
Subject:	trigger question.
Date:	2003-03-25 16:01:58
Message-ID:	OFE53E6E2C.78FC5E25-ONC1256CF4.005593E8@ac750.recouv
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: trigger question. at 2003-03-11 05:06:36 from shreedhar
Re: trigger question. at 2003-03-25 16:16:27 from Shridhar Daithankar<shridhar_daithankar@nospam.persistent.co.in>

Browse pgsql-general by date

	From	Date	Subject
Next Message	scott.marlowe	2003-03-25 16:03:39	Re: '' <> NULL
Previous Message	Flower Sun	2003-03-25 15:29:16	Turple level or object level OIDs?