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

Re: dropping a foreign key

From: "Dan Langille" <dan(at)langille(dot)org>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: dropping a foreign key
Date: 2003-03-05 16:41:00
Message-ID: 3E65E24C.13145.B2AF42B@localhost (view raw or flat)
Thread:
Lists: pgadmin-support
On 5 Mar 2003 at 16:33, Dave Page wrote:

> > -----Original Message-----
> > From: Dan Langille [mailto:dan(at)langille(dot)org] 
> > Sent: 05 March 2003 16:21
> > To: pgadmin-support(at)postgresql(dot)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/


In response to

pgadmin-support by date

Next:From: Lonni J FriedmanDate: 2003-03-05 21:07:17
Subject: pg_restore problem
Previous:From: Dave PageDate: 2003-03-05 16:33:13
Subject: Re: dropping a foreign key

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