Re: [BUGS] BUG #1079: ALTER TABLE does not add foreign key

2004-05-26 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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 --

Re: [BUGS] BUG #1079: ALTER TABLE does not add foreign key

2004-02-11 Thread Richard Huxton
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:

[BUGS] BUG #1079: ALTER TABLE does not add foreign key

2004-02-11 Thread PostgreSQL Bugs List
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