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(at)densoft(dot)com(dot)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