On Tue, 4 Feb 2003, Vilson farias wrote:
>
> Ok, but I'm having some problems to identify wich triggers should be
> destroyed. How can I remove those triggers? Can I just delete these records
> from pg_trigger?
>
> ALTER TABLE cham_atendimento
> ADD CONSTRAINT RLoginXAtend FOREIGN KEY (pa, dt_login)
> REFERENCES pa__login;
>
> bxs=# select * from pg_trigger where tgconstrname = 'rloginxatend';
- These three constraints are the ones you need
> bxs=# drop trigger RI_ConstraintTrigger_20885 on cham_atendimento;
> ERROR: DropTrigger: there is no trigger ri_constrainttrigger_20885 on
> relation cham_atendimento
> bxs=# drop trigger RI_ConstraintTrigger_20885 on pa__login;
> ERROR: DropTrigger: there is no trigger ri_constrainttrigger_20885 on
> relation pa__login
>
> How can I remove those triggers? Can I just delete these records from
You'll need to double quote the names because they're mixed case.
> pg_trigger?
Not without also altering reltriggers on pg_class.