dropped it. One of its columns referenced users.user_id. Now
whenever I try to update users, I get results like this:
bf2-new=# update users set last_visit=sysdate() where user_id=4;
ERROR: Relation 'user_comments' does not exist
It looks like somehow a trigger that should have been dropped
wasn't. I tried playing with pg_trigger and pg_class but if I'm not
mistaken (select tgname from pg_trigger where tgrelid = (select
relfilenode from pg_class where relname = 'users')) I have 466
triggers on the users table, mostly "annonymous" referential
integrity constraints. RI_ConstraintTrigger_43426, etc. Is there
any way to drop the right ones without going through a dump and
manually whacking out references to user_comments?
PG 7.1.1 btw.