Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc SCHAEFER
Subject Re: foreign keys constraints, depending on each other
Date
Msg-id Pine.LNX.3.96.1010611120121.1200A-100000@defian.alphanet.ch
Whole thread Raw
In response to foreign keys constraints, depending on each other  (zilch@home.se)
Responses Re: foreign keys constraints, depending on each other  (zilch@home.se)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Olivier Cherrier
Date:
Subject: RE: libpq compile error
Next
From: zilch@home.se
Date:
Subject: Re: foreign keys constraints, depending on each other