Skip site navigation (1) Skip section navigation (2)

BUG #1079: ALTER TABLE does not add foreign key

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1079: ALTER TABLE does not add foreign key
Date: 2004-02-11 17:29:30
Message-ID: 20040211172930.D6E07CF4804@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1079
Logged by:          Vladimir Sitarchuk

Email address:      vova(at)densoft(dot)com(dot)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.



Responses

pgsql-bugs by date

Next:From: Richard HuxtonDate: 2004-02-11 18:44:56
Subject: Re: BUG #1079: ALTER TABLE does not add foreign key
Previous:From: PostgreSQL Bugs ListDate: 2004-02-11 13:56:15
Subject: BUG #1078: Ref #1045 hostname lookup does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group