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

From Stephan Szabo
Subject Re: Foreign Key constraint and Alter Table command
Date
Msg-id Pine.BSF.4.21.0012121704010.34132-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Foreign Key constraint and Alter Table command  (Carlos Felipe Zirbes <carlosz@dbserver.com.br>)
List pgsql-general
On Tue, 12 Dec 2000, Carlos Felipe Zirbes wrote:

> 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?

Strange, the above statement works for me in 7.0.2 once I make a foo
and foo_2 table.  Can you do a select version(); ?



pgsql-general by date:

Previous
From: Tim Kientzle
Date:
Subject: TOAST != BLOB (was Re: Unanswered questions about Postgre)
Next
From: "George Johnson"
Date:
Subject: Re: Too much traffic