Обсуждение: DROP TRIGGER

Поиск
Список
Период
Сортировка

DROP TRIGGER

От
Elielson Fontanezi
Дата:
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
---------------------------(    )----------(    )--------------------------------
                            \  (            )  /
                             \_/            \_/

 

Re: DROP TRIGGER

От
Stephan Szabo
Дата:
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.