> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ümit Öztosun
> Sent: Tuesday, February 06, 2007 2:50 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Very strange error
>
>
> Hi,
>
> Today suddenly our PostgreSQL 8.1 server started producing strange errors.
Error occurs during simple updates:
>
> "Table has type character varying, but query expects character varying."
>
> We are still trying to figure out the problem. I've googled for this error
but found nothing. Any insight?
>
> Platform: Ubuntu Dapper, Running PostgreSQL 8.1 (vanilla packages from
Ubuntu), UTF-8 and non-US locale.
>
> Regards,
> --
> Ümit Öztosun
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.
Greetings,
Matthias