| From: | Larry Rosenman <ler(at)lerctr(dot)org> | 
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org | 
| Subject: | Re: REFERENCES in a field | 
| Date: | 2000-10-29 02:29:06 | 
| Message-ID: | 20001028212906.A3096@lerami.lerctr.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
I assume you are using a version before 7.0.  Please upgrade to 7.0.2
which is the current release, and supports foreign keys.
Larry Rosenman
* Fernando M. Maresca <fmaresca(at)netverk(dot)com(dot)ar> [001028 18:41]:
> 
> Hi!
>  When I try to insert a FOREIGN KEY in a field while I'm create a table
> with psql in the form:
> 
> create table table (
> field1 CHAR(10) PRIMARY KEY,
> field2 CHAR(10) REFERENCES table0
> );
> 
> psql returns an error that tells "FOREIGN KEYS not implemented yet".
> I'm running Postgres version 6.5.3, which version supports foreign keys?
> 
> Thank you,
> Fernando
> 
> 
> 
-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando M. Maresca | 2000-10-29 23:36:40 | REFERENCES in a field | 
| Previous Message | Albert REINER | 2000-10-28 14:36:14 | Re: |