DROP TRIGGER
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
---------------------------( )----------(
)--------------------------------
\ ( ) /
\_/ \_/
On Fri, 1 Aug 2003, Elielson Fontanezi wrote:
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');
DROP TRIGGER "fk_participante_evento_1" on servidor;
should work I think. Was that manually created or as
part of a foreign key? If the latter, dropping just one
of the triggers is probably unsafe.