Re: [BUGS] BUG #4120: ERROR: cache lookup failed for function 0

2008-04-21 Thread Tom Lane
Pedro Gimeno <[EMAIL PROTECTED]> writes: > Tom Lane wrote: > Here's a minimal test case: > pruebas=# CREATE FUNCTION vc_gt(varchar,varchar) RETURNS boolean > IMMUTABLE STRICT LANGUAGE SQL AS 'SELECT CAST($1 AS TEXT) > CAST($2 AS > TEXT);'; > CREATE FUNCTION > pruebas=# CREATE OPERATOR > ( >

Re: [BUGS] BUG #4120: ERROR: cache lookup failed for function 0

2008-04-21 Thread Pedro Gimeno
Tom Lane wrote: >> postgres=# select ''::varchar < ''::varchar; >> ERROR: cache lookup failed for function 0 > > Interesting. The symptom sounds vaguely familiar, though I can't find > any relevant-looking CVS log entries right now. I'd suggest updating to > 8.2.7 before you spend much time loo

Re: [BUGS] BUG #4120: ERROR: cache lookup failed for function 0

2008-04-21 Thread Tom Lane
"Pedro Gimeno" <[EMAIL PROTECTED]> writes: > I have an application running under Windows (tried both with XP and 2000) > which when run, gets the server to a point in which every comparison of > varchar < varchar gives the above error: > postgres=# select ''::varchar < ''::varchar; > ERROR: cache

[BUGS] BUG #4120: ERROR: cache lookup failed for function 0

2008-04-21 Thread Pedro Gimeno
The following bug has been logged online: Bug reference: 4120 Logged by: Pedro Gimeno Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Debian Etch + Backports Description:ERROR: cache lookup failed for function 0 Details: I have an applic