[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq