| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Carlos Felipe Zirbes <carlosz(at)dbserver(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Foreign Key constraint and Alter Table command |
| Date: | 2000-12-13 01:07:12 |
| Message-ID: | Pine.BSF.4.21.0012121704010.34132-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(); ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Kientzle | 2000-12-13 01:14:45 | TOAST != BLOB (was Re: Unanswered questions about Postgre) |
| Previous Message | MEOW961021 | 2000-12-12 22:16:20 | info please |