Re: Very strange error

From: Matthias(dot)Pitzl(at)izb(dot)de
To: umit(at)ly(dot)com(dot)tr
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very strange error
Date: 2007-02-06 15:12:20
Message-ID: 11EC9A592C31034C88965C87AF18C2A7027177D9@m0000s61
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Ümit Öztosun
Sent: Tuesday, February 06, 2007 3:59 PM
To: Matthias(dot)Pitzl(at)izb(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Very strange error

Have you installed any updates for PostgreSQL? The latest security update
fixed something with type checks or so.
I've seen the same error message also on the BUGS mailing list concerning a
broken CHECK constraint on a table row.
Perhaps this is the cause of the error messages.

Well, I've just dumped old data, installed v8.2.2 from sources, restored
data. Unfortunately the error remains the same and we have no ideas left.
Error is again:

"Table has type character varying, but query expects character varying."

The error is about a varchar column, with no other special attributed. It
was working flawlessly for a long time.

Any help is appreciated.

Regards,
Ümit Öztosun

Hello there!

I suggest to post this on the BUGS mailing list. As said before, there has
been some other mail with exact the same error message and with the latest
version something concerning data type checks had been fixed.

Greetings,
Matthias

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-02-06 15:16:46 Re: Retrieving affected tables
Previous Message Michael Slattery 2007-02-06 15:09:16 Re: Very strange error