Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade

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?