Thread: dropping a foreign key

dropping a foreign key

From

"Dan Langille"

Date:

05 March 2003, 14:17:26

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?

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

Re: dropping a foreign key

From

"Dave Page"

Date:

05 March 2003, 14:33:10


> -----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.

Regards, Dave.

Re: dropping a foreign key

From

"Dan Langille"

Date:

05 March 2003, 14:37:00

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/