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