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. +