Re: foreign keys constraints, depending on each other

From: Mario Weilguni <Mario(dot)Weilguni(at)kpnqwest(dot)com>
To: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>, pgsql-general(at)postgresql(dot)org
Subject: Re: foreign keys constraints, depending on each other
Date: 2001-06-11 09:47:34
Message-ID: 200106110943.f5B9hufn015828@relay2.austria.eu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(dot)weilguni(at)kpnqwest(dot)com
===================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olivier Cherrier 2001-06-11 10:00:29 RE: libpq compile error
Previous Message Marc SCHAEFER 2001-06-11 08:25:45 Re: foreign keys constraints, depending on each other