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: [EMAIL PROTECTED] > > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
