Foreign Key constraint and Alter Table command - Mailing list pgsql-general

From Carlos Felipe Zirbes
Subject Foreign Key constraint and Alter Table command
Date
Msg-id 002DEF4E7A9FD411A6BD000021498C33030931@TERRA
Whole thread Raw
Responses Re: Foreign Key constraint and Alter Table command  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hi.
 
I am using postgres 7.0.can't_remember_the_rest and I am not able to add a FK via alter table command. When I try to do it I get an "Feature not implemented" error message. This is what I've been trying to do:
 
alter table foo
add constraint foo_fk
foreign key (a) references foo_2
 
where "a" is a column name in foo.
 
I thought I would be able to add constraints via alter table by using pgsql 7. Was I wrong?
 
Thanks in advance,
Zirbes

pgsql-general by date:

Previous
From: "Jon Brace"
Date:
Subject: Loading tables into Memory
Next
From: Steve Heaven
Date:
Subject: Re: Sql query with partial matching