Re: many columns with references to one table

From: Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: many columns with references to one table
Date: 2003-08-26 15:19:22
Message-ID: 3F4B7A7A.8050006@physik.uni-erlangen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)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
>
>
Well, the demonstration effect...
After a complete rewrite of my Database-generating sql-file the problem
is solved. Don't know what I did wrong the first time, but it's working
now. The curious thing is that I didn't made anything different in this
part.

Thanks

Andreas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-26 15:34:36 Re: 7.4b1 vs 7.3.4 performance
Previous Message Bruce Momjian 2003-08-26 15:17:20 Re: 7.4b1 vs 7.3.4 performance