Re: 7.4 - TODO : alter table drop foreign key

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


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Berndtsson 2002-12-05 16:22:18 Re: big text field -> message type 0x44
Previous Message Doug McNaught 2002-12-05 16:16:13 Re: big text field -> message type 0x44