On Feb 6, 2007, at 9:54 AM, Andrew Sullivan wrote:
> On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote:
>> DETAIL: Table has type character varying, but query expects
>> character varying.
>
> In another thread, someone else is reporting this too. I'm
> wondering whether something went wrong in the 8.2.2 release.
The error message originates in backend/executor/
nodeFunctionscan.c:tupledesc_match. In this case the error is being
caused by having a functional index (lower(fieldname)) on a table.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)