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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Lonni J Friedman | 2003-03-05 21:07:17 | pg_restore problem |
Previous Message | Dave Page | 2003-03-05 16:33:13 | Re: dropping a foreign key |