Re: Violation of non existing reference

From: js(at)deriva(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Violation of non existing reference
Date: 2008-03-06 19:40:59
Message-ID: 43c6f072-e66f-4bd9-95c2-e1896499fbcf@8g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Tyndall 2008-03-06 19:55:33 Cannot Install PostgreSQL on Windows 2000 Server
Previous Message Bruce Momjian 2008-03-06 18:50:36 Re: [GENERAL] advisory locks: documentation hint and feature request