Re: orphaned trigger
Jonathan Ellis <jellis@advocast.com>
From: "Jonathan Ellis" <jellis@advocast.com>
To: <pgsql-bugs@postgresql.org>
Date: 2001-05-16T22:57:34Z
Lists: pgsql-bugs
> > Would manually > > removing it from pg_trigger cause Bad Things to happen? > > Yes, and you'll need to double quote the trigger name. > try > drop trigger "RI_ConstraintTrigger_44349" on users; That worked. Why was that? > How did you drop the table? Did you reload a dump file (like the one that > referenced it)? I'm afraid I don't understand the question. I dropped it with drop table. Although thinking back on it, the drop may have been on 7.0.2. Can't remember whether that was before or after upgrading... -Jonathan