Re: [SQL] Adding foreign key constraint post table creation

On Monday 09 Dec 2002 4:11 pm, Charles Hauser wrote: > All, > > A couple of novice questions: > > > I would like to modify an existing TABLE by addinga new column (FOREIGN > KEY): > >type_id int not null, >foreign key (type_id) references cvterm (cvterm_id), > > > Will this work ( r

[SQL] Adding foreign key constraint post table creation

All, A couple of novice questions: I would like to modify an existing TABLE by addinga new column (FOREIGN KEY): type_id int not null, foreign key (type_id) references cvterm (cvterm_id), Will this work ( running PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96): AL