Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade

On Feb 6, 10:33 am, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> "Thomas F. O'Connell" <t(dot)(dot)(dot)(at)o(dot)ptimized(dot)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:

http://archives.postgresql.org/pgsql-hackers/2007-02/msg00276.php

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 :

http://o.ptimized.com/
615-260-0005