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 20070206174501.GK9481@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: "Ümit Öztosun"
Date:
Subject: Re: Strange "Table has type character varying, but query expects character varying" errors
Next
From: Martin Pitt
Date:
Subject: Re: BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'