Re: 7.4 - TODO : alter table drop foreign key

From: "Dan Langille" <dan(at)langille(dot)org>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.4 - TODO : alter table drop foreign key
Date: 2002-12-05 16:24:36
Message-ID: 3DEF3774.26629.6702432@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5 Dec 2002 at 8:20, Stephan Szabo wrote:

>
> On Thu, 5 Dec 2002, Dan Langille wrote:
>
> > We support "alter table add foreign key". How about supporting
> > "alter table drop foreign key"?
> >
> > - he said as he went to drop a foreign key
>
> It seems to work for me on my 7.3b2 system with
> alter table <table> drop constraint <constraint name>;

How was that FK added? How did you determine the constraint name?
--
Dan Langille : http://www.langille.org/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Langille 2002-12-05 16:28:33 Re: 7.4 - TODO : alter table drop foreign key
Previous Message Tomas Berndtsson 2002-12-05 16:23:55 Re: big text field -> message type 0x44