Re: BUG #1079: ALTER TABLE does not add foreign key - Mailing list pgsql-bugs

From Richard Huxton
Subject Re: BUG #1079: ALTER TABLE does not add foreign key
Date
Msg-id 200402111844.56307.dev@archonet.com
Whole thread Raw
In response to BUG #1079: ALTER TABLE does not add foreign key  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
On Wednesday 11 February 2004 17:29, PostgreSQL Bugs List wrote:
> The following bug has been logged online:
>
> Bug reference:      1079
> Logged by:          Vladimir Sitarchuk
> Email address:      vova@densoft.com.ua
>
> PostgreSQL version: 7.3
> Operating system:   Red Hat 9
> Description:        ALTER TABLE does not add foreign key
>
> Details:
> ALTER TABLE tablename ADD COLUMN columnname INT CONSTRAIN cntrname
> REFERENCES tablename2(col)
> adds the column But it does not add the foreign key constrain.

Perhaps the manual should be clearer on this.

You can add a foreign key with something like (example from manual):
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address)
REFERENCES addresses(address) MATCH FULL;
--
  Richard Huxton
  Archonet Ltd

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1079: ALTER TABLE does not add foreign key
Next
From: Tom Lane
Date:
Subject: Re: BUG #1079: ALTER TABLE does not add foreign key