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

From Dan Langille
Subject Re: 7.4 - TODO : alter table drop foreign key
Date
Msg-id 3DEF3774.26629.6702432@localhost
Whole thread Raw
In response to Re: 7.4 - TODO : alter table drop foreign key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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/



pgsql-hackers by date:

Previous
From: Tomas Berndtsson
Date:
Subject: Re: big text field -> message type 0x44
Next
From: "Dan Langille"
Date:
Subject: Re: 7.4 - TODO : alter table drop foreign key