Re: Strange "Table has type character varying, but query expects character varying" errors

From: Martin Pitt <martin(dot)pitt(at)ubuntu(dot)com>
To: Ümit Öztosun <umit(at)ly(dot)com(dot)tr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Strange "Table has type character varying, but query expects character varying" errors
Date: 2007-02-06 17:15:42
Message-ID: 20070206171542.GJ9481@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Ümit,

Ümit Öztosun [2007-02-06 17:57 +0200]:
> Today two of our production servers developed the following error(s):
>
> ERROR: attribute X(semi-random number here) has wrong type
> DETAIL: Table has type character varying, but query expects character
> varying.
>
> They were running PostgreSQL 8.1.4 on Ubuntu Dapper, dual-core Intel
> 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
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2007-02-06 17:45:01 Re: Strange "Table has type character varying, but query expects character varying" errors
Previous Message Ümit Öztosun 2007-02-06 16:54:53 Re: Strange "Table has type character varying, but query expects character varying" errors