Re: Foreign Key Implementation

The documentation in 7.0 is rather obsolete, sorry for inconvenience. The
release will hopefully contain all information. Here is an example for
basic foreign key definition:

create table group(id serial, name varchar(20));
create table member(id serial, name varchar(30), group int4references group(id));

The following has the same result:

create table group(id serial, name varchar(20));
create table member(id serial, name varchar(30), group int4,foreign key id references group(id)on update restrict on
deleterestrict);
 

I hope this helps.

Regards,
Zoltan