Re: orphaned trigger

From: "Jonathan Ellis" <jellis(at)advocast(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: orphaned trigger
Date: 2001-05-16 22:57:34
Message-ID: 00e601c0de5b$991d2c30$5a050a0a@devjellis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-05-16 22:59:40 Re: date bug
Previous Message Stephan Szabo 2001-05-16 22:14:20 Re: orphaned trigger