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