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

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.