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

From Thomas F. O'Connell
Subject Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
Date
Msg-id BF4741D2-7AB3-4E13-9A78-59FA3498EA94@o.ptimized.com
Whole thread Raw
In response to PostgreSQL on Solaris: Changing Compilers During Point Upgrade  ("Thomas F. O'Connell" <tf@o.ptimized.com>)
Responses Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
List pgsql-general
On Feb 6, 10:33 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
> "Thomas F. O'Connell" <t...@o.ptimized.com> writes:
>
> > but we just built 8.2.2 from source using cc, and now we're seeing  
> > this type of error in the logs:
> > ERROR:  attribute 3 has wrong type
> > DETAIL:  Table has type character varying, but query expects  
> > character varying.
>
> This has nothing to do with your compiler :-(

I just wanted to eliminate that variable. It took me a while to track down the source of the error in the source.

I saw this nearby thread on -hackers:


The tables in question generating these errors in this database do indeed have functional indexes. Is there a known fix, or does this qualify as a bug?

--
Thomas F. O'Connell

optimizing modern web applications
: for search engines, for usability, and for performance :

615-260-0005

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cursor timeout in postgres
Next
From: Alan Hodgson
Date:
Subject: Re: Creating an index on a live database