Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.4 - TODO : alter table drop foreign key - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: 7.4 - TODO : alter table drop foreign key
Date
Msg-id 20021205081944.A1748-100000@megazone23.bigpanda.com
Whole thread Raw
In response to 7.4 - TODO : alter table drop foreign key  ("Dan Langille" <dan@langille.org>)
Responses Re: 7.4 - TODO : alter table drop foreign key
Re: 7.4 - TODO : alter table drop foreign key
List pgsql-hackers
Tree view 
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>;

pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: big text field -> message type 0x44
Next
From: Tomas Berndtsson
Date:
Subject: Re: big text field -> message type 0x44