Thomas F. O'Connell wrote: > On Feb 6, 10:33 am, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > > "Thomas F. O'Connell" <t...@xxxxxxxxxxxxxx> 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@xxxxxxxxxx Homepage http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
