Re: Foreign Key Implementation

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: "Alexey V(dot) Meledin" <avm(at)webclub(dot)ru>
Cc: "Drozdowski, Catharine I" <Drozdowski(dot)Catharine(at)emeryworld(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Foreign Key Implementation
Date: 2000-04-05 09:43:53
Message-ID: Pine.LNX.4.05.10004051137250.4358-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 int4
references 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 delete restrict);

I hope this helps.

Regards,
Zoltan

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Larry ganga giri 2000-04-05 13:03:48 Is Pgsql an OORDBMS?
Previous Message Alexey V. Meledin 2000-04-05 09:20:23 Re[2]: planner/optimizer hash index method and so on