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
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 |