Re: orphaned trigger - Mailing list pgsql-bugs

From Jonathan Ellis
Subject Re: orphaned trigger
Date
Msg-id 00e601c0de5b$991d2c30$5a050a0a@devjellis
Whole thread Raw
In response to Re: orphaned trigger  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: orphaned trigger  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: orphaned trigger
Next
From: Tom Lane
Date:
Subject: Re: date bug