The following bug has been logged online:

Bug reference: 1079
Logged by: Vladimir Sitarchuk

Email address: vova (AT) densoft (DOT) 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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

On Wednesday 11 February 2004 17:29, PostgreSQL Bugs List wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
This was fixed as of 7.3.3.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org