Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group