Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign keys constraints, depending on each other - Mailing list pgsql-general

From Mario Weilguni
Subject Re: foreign keys constraints, depending on each other
Date
Msg-id 200106110943.f5B9hufn015828@relay2.austria.eu.net
Whole thread Raw
In response to Re: foreign keys constraints, depending on each other  (Marc SCHAEFER <schaefer@alphanet.ch>)
List pgsql-general
Tree view 
Am Montag, 11. Juni 2001 10:25 schrieb Marc SCHAEFER:
> I would remove the father and mother references, and add a
>    is_married
> relation; as a table, with a UNIQUE(father_id), UNIQUE(mother_id)
> constraint (a person can be only married once).

Is not true, at least not in some arabic countries.

--
===================================================
 Mario Weilguni                               KPNQwest Austria GmbH
 Senior Engineer Web Solutions                         Nikolaiplatz 4
 tel: +43-316-813824                                8020 graz, austria
 fax: +43-316-813824-26                    http://www.kpnqwest.at
 e-mail: mario.weilguni@kpnqwest.com
===================================================

pgsql-general by date:

Previous
From: "Ognyan Kulev"
Date:
Subject: Database per user quotas
Next
From: nj7e@yahoo.com (John Moore)
Date:
Subject: Does PostgreSQL have implicit Order-by