Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade - Mailing list pgsql-general

From Jim Nasby
Subject Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
Date
Msg-id 946E8E87-14CD-4B74-824D-2AC74529BE5E@decibel.org
Whole thread Raw
In response to Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
On Feb 6, 2007, at 9:54 AM, Andrew Sullivan wrote:
> On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote:
>> DETAIL:  Table has type character varying, but query expects
>> character varying.
>
> In another thread, someone else is reporting this too.  I'm
> wondering whether something went wrong in the 8.2.2 release.

The error message originates in backend/executor/
nodeFunctionscan.c:tupledesc_match. In this case the error is being
caused by having a functional index (lower(fieldname)) on a table.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-general by date:

Previous
From: Ron Peterson
Date:
Subject: Re: create operator class problem
Next
From: "Hiltibidal, Robert"
Date:
Subject: Re: Storing database in cluster (Memory)