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

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.

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

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> ALTER TABLE tablename ADD COLUMN columnname INT CONSTRAIN cntrname
> REFERENCES tablename2(col)
> adds the column But it does not add the foreign key constrain.

This was fixed as of 7.3.3.

            regards, tom lane