Re: DROP TRIGGER

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.