Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange "Table has type character varying, but query expects character varying" errors - Mailing list pgsql-bugs

From Martin Pitt
Subject Re: Strange "Table has type character varying, but query expects character varying" errors
Date
Msg-id 20070206171542.GJ9481@piware.de
Whole thread Raw
In response to Strange "Table has type character varying, but query expects character varying" errors  ("Ümit Öztosun" <umit@ly.com.tr>)
List pgsql-bugs
Tree view 
Hi =DCmit,

=DCmit =D6ztosun [2007-02-06 17:57 +0200]:
> Today two of our production servers developed the following error(s):
>=20
> ERROR:  attribute X(semi-random number here) has wrong type
> DETAIL:  Table has type character varying, but query expects character=20
> varying.
>=20
> They were running PostgreSQL 8.1.4 on Ubuntu Dapper, dual-core Intel=20
> Machines.

Right, that is the same issue I already reported to this list, and is
already reported in Launchpad, too: https://launchpad.net/bugs/83505

Martin
--=20
Martin Pitt        http://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #2961: NULL values in subselects force NOT IN to false
Next
From: "Thomas"
Date:
Subject: BUG #2973: Compile Error with MIPSpro compiler