Обсуждение: REFERENCES in a field

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

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@netverk.com.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749