Thomas F. O'Connell wrote: > On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote: > > "Thomas F. O'Connell" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Homepage http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
