Re: trigger question.
You can drop and create triggers with the following commands.
DROP TRIGGER TriggerName ON TableName;
CREATE TRIGGER TriggerName AFTER/BEFORE INSERT/DELETE/UPDATE ON TableName
FOR EACH ROW EXECUTE PROCEDURE ProcedureName;
Sreedhar
----- Original Message -----
From: <alain.bruneau@acoss.fr>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, March 25, 2003 9:31 PM
Subject: [GENERAL] trigger question.
Show quoted text
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.---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Import Notes
Reference msg id not found: OFE53E6E2C.78FC5E25-ONC1256CF4.005593E8@ac750.recouv