Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade

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

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(at)momjian(dot)us
Homepage http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +