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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend