Re: foreign keys constraints, depending on each other

From: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>
To: Mario Weilguni <Mario(dot)Weilguni(at)kpnqwest(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign keys constraints, depending on each other
Date: 2001-06-11 10:01:48
Message-ID: Pine.LNX.3.96.1010611120121.1200A-100000@defian.alphanet.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 11 Jun 2001, Mario Weilguni wrote:

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

in that case my model is even better since it *allows* for that case (by
removing the UNIQUE constraints), where the REFERENCES model has an issue.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zilch 2001-06-11 11:35:19 Re: foreign keys constraints, depending on each other
Previous Message Olivier Cherrier 2001-06-11 10:00:29 RE: libpq compile error