Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade

Thomas F. O'Connell wrote:
> 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:
>
> 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?

It is a bug.  There is a patch committed to CVS, and we are working to
figure out how to distribute this fix.

--
  Bruce Momjian   bruce@momjian.us
  Homepage        http://momjian.us
  EnterpriseDB    http://www.enterprisedb.com
  + If your life is a hard drive, Christ can be your backup. +