Re: dropping a foreign key - Mailing list pgadmin-support

From Dan Langille
Subject Re: dropping a foreign key
Date
Msg-id 3E65E24C.13145.B2AF42B@localhost
Whole thread Raw
In response to Re: dropping a foreign key  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
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/


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: dropping a foreign key
Next
From: Lonni J Friedman
Date:
Subject: pg_restore problem