Re: BUG #1079: ALTER TABLE does not add foreign key

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