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