Re: Foreign Key Implementation - Mailing list pgsql-sql

From Kovacs Zoltan Sandor
Subject Re: Foreign Key Implementation
Date
Msg-id Pine.LNX.4.05.10004051137250.4358-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Re: Foreign Key Implementation  ("Alexey V. Meledin" <avm@webclub.ru>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Alexey V. Meledin"
Date:
Subject: Re[2]: planner/optimizer hash index method and so on
Next
From: "Larry ganga giri"
Date:
Subject: Is Pgsql an OORDBMS?