Re: 7.4 - TODO : alter table drop foreign key

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Dan Langille" <dan(at)langille(dot)org>, "Rod Taylor" <rbt(at)rbt(dot)ca>
Cc: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.4 - TODO : alter table drop foreign key
Date: 2002-12-05 19:52:08
Message-ID: 01f101c29c97$cba66670$6500a8c0@internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Langille 2002-12-05 19:58:38 Re: 7.4 - TODO : alter table drop foreign key
Previous Message Dan Langille 2002-12-05 19:51:34 Re: 7.4 - TODO : alter table drop foreign key