Re: many columns with references to one table - Mailing list pgsql-general

From Tom Lane
Subject Re: many columns with references to one table
Date
Msg-id 11616.1061907468@sss.pgh.pa.us
Whole thread Raw
In response to many columns with references to one table  (Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>)
List pgsql-general
Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de> writes:
> My problem is that the references to the phones table do not get
> restricted, i.e. I can insert any value in the phone*-fields, while the
> references to the other tables are restricted to values that allready
> exists.

Hard to believe --- and I couldn't reproduce it here.  What PG version
are you using?  Can you show us a complete example?

            regards, tom lane

pgsql-general by date:

Previous
From: Pedro Alves
Date:
Subject: Re: Index usage
Next
From: Andreas Fromm
Date:
Subject: deleting referenced data