Re: dropping a foreign key

On 5 Mar 2003 at 16:33, Dave Page wrote:

> > -----Original Message-----
> > From: Dan Langille [mailto:dan@langille.org]
> > Sent: 05 March 2003 16:21
> > To: pgadmin-support@postgresql.org
> > Subject: [pgadmin-support] dropping a foreign key
> >
> >
> > Should pgadmin be able to drop a foreign key?
> >
> > I right click on the FK, then click on Drop Object, click on Yes,
> > then get told "Foreign Key objects cannot be dropped".
> >
> > Why?
>
> Mainly because no-one has implemented that functionality. I have added
> an item to the todo list.

Well, that's a good reason.  :)  Just checking.  In the meantime, I
have done it manually:

alter table watch_list_staging drop constraint "ABC";

Cheers.
--
Dan Langille : http://www.langille.org/