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

From Christopher Kings-Lynne
Subject Re: 7.4 - TODO : alter table drop foreign key
Date
Msg-id 01f101c29c97$cba66670$6500a8c0@internal
Whole thread Raw
In response to Re: 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
> > > Thanks.  I guess I should rename my thread to 7.4 - TODO : allow
> > > constraint names when using the "ALTER TABLE <table> ADD FOREIGN KEY"
> > > syntax.
> >
> > You can do that now.
> >
> > ALTER TABLE <table> ADD CONSTRAINT <const> FOREIGN KEY ....
>
> That I know.  That syntax is radically different from that proposed.

Isn't it identical?  The CONSTRAINT <const> is SQL standard optional clause
for all commands that add constraints.

Chris



pgsql-hackers by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: 7.4 - TODO : alter table drop foreign key
Next
From: "Dan Langille"
Date:
Subject: Re: 7.4 - TODO : alter table drop foreign key