Re: trigger question.
От | shreedhar |
---|---|
Тема | Re: trigger question. |
Дата | |
Msg-id | 00da01c2e78c$00458930$1201a8c0@a4005 обсуждение исходный текст |
Ответ на | trigger question. (alain.bruneau@acoss.fr) |
Список | pgsql-general |
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. > 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)
В списке pgsql-general по дате отправления: