> > Would manually
> > removing it from pg_trigger cause Bad Things to happen?
> Yes, and you'll need to double quote the trigger name.
> 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...
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-05-16 22:59:40|
|Subject: Re: date bug |
|Previous:||From: Stephan Szabo||Date: 2001-05-16 22:14:20|
|Subject: Re: orphaned trigger|