On 5 Mar 2003 at 16:33, Dave Page wrote: > > -----Original Message----- > > From: Dan Langille [mailto:[EMAIL PROTECTED] > > Sent: 05 March 2003 16:21 > > To: [EMAIL PROTECTED] > > 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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster