Re: Violation of non existing reference - Mailing list pgsql-general

From js@deriva.de
Subject Re: Violation of non existing reference
Date
Msg-id 43c6f072-e66f-4bd9-95c2-e1896499fbcf@8g2000hse.googlegroups.com
Whole thread Raw
In response to Violation of non existing reference  (js@deriva.de)
Responses Re: Violation of non existing reference  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
It's Version 8.3.
Both columns are of a user defined datatype which is a varchar(12)
with a special check.
I already did a REINDEX but it didn't help.


On 6 Mrz., 18:27, t...@sss.pgh.pa.us (Tom Lane) wrote:
> What PG version is this?  Are the two columns of identical datatypes?
> (I'm wondering about possible funny effects from blank-padding rules,
> for example, if one is char and the other is text or varchar.)
> You might also try REINDEXing both tables just in case the problem is a
> corrupt index.

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: I'm in need of something that should be there
Next
From: "Ron Tyndall"
Date:
Subject: Cannot Install PostgreSQL on Windows 2000 Server