Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1079: ALTER TABLE does not add foreign key
Date
Msg-id 7198.1076527064@sss.pgh.pa.us
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
Tree view 
"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

pgsql-bugs by date:

Previous
From: Richard Huxton
Date:
Subject: Re: BUG #1079: ALTER TABLE does not add foreign key
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1080: Ref #1045 resolved