Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-05-16 22:59:40
Subject: Re: date bug
Previous:From: Stephan SzaboDate: 2001-05-16 22:14:20
Subject: Re: orphaned trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group