Re: one to many

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: one to many
Date: 2004-05-16 17:17:49
Message-ID: 40A7A23D.3080008@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Eisentraut wrote:

>Dennis Gearon wrote:
>
>
>>How do I set up a one to many relationship in Postgres, (any DB for
>>that matter.)
>>
>>
>
>Read about foreign keys:
>
>http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK
>
>
>
That only takes care of if the PARENT is deleted/updated, if I read it
right. I'm trying to take care of the case where the CHILD is deleted or
updated, i.e. preserving 1-Many part of a rlationship.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scot L. Harris 2004-05-16 20:22:11 table column information
Previous Message Peter Eisentraut 2004-05-16 17:04:10 Re: one to many