Re: should I worry?

ohp@pyrenet.fr writes:
> IIUC, I have drop every trigger like this :

> SELECT t.tgname, c.relname, tgconstrname FROM pg_trigger t, pg_class c
> WHERE t.tgrelid = c.oid AND tgname like 'RI_ConstraintTrigger_%'AND
> tgconstrname = '<unnamed>';

> and I delete all those ancient foreign key WITHOUT disturbing any others
> Is that right?

Not necessarily --- are you sure you don't have any real constraints
named "<unnamed>"?

However, if you do, the DROP TRIGGER command will just fail, so maybe
you don't need to bother with looking into pg_depend for yourself.

			regards, tom lane