DROP TRIGGER

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: DROP TRIGGER
Date: 2003-08-01 18:06:43
Message-ID: A799F7647794D311924A005004ACEA97096997C1@cprodamibs249.prodam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!

I am sorry, but is there a way to drop a trigger like this one?

CREATE CONSTRAINT TRIGGER fk_participante_evento_1
AFTER INSERT OR UPDATE ON participante_evento
FROM servidor
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_participante_evento_1',
'participant
e_evento', 'servidor', 'UNSPECIFIED', 'cd_reg_funcional',
'cd_reg_funcional');

>\\\!/< 55 11 5080 9283
!_"""_! Elielson Fontanezi
(O) (o) PRODAM - Technical Support
Analyst
-------------------------------oOOO--(_)--OOOo------------------------------
-----
Success usually comes to those who are too busy to be looking for it.
oooo0 0oooo
---------------------------( )----------(
)--------------------------------
\ ( ) /
\_/ \_/


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elielson Fontanezi 2003-08-01 18:09:59 ERROR: stat failed on file '$libdir/plpgsql': No such file or di rectory
Previous Message Jenny Zhang 2003-08-01 18:04:10 OSDL Database Test Suite 3 is available on PostgreSQL