Postgres Pro
Downloads
Home   >   mailing lists

Re: Using CASE in plpgsql causes 'ERROR: cache lookup failed' - Mailing list pgsql-sql

From Tom Lane
Subject Re: Using CASE in plpgsql causes 'ERROR: cache lookup failed'
Date
Msg-id 16679.1271286699@sss.pgh.pa.us
Whole thread Raw
In response to Using CASE in plpgsql causes 'ERROR: cache lookup failed'  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-sql
Tree view 
Mario Splivalo <mario.splivalo@megafon.hr> writes:
> When I call 'service_something' function and provide nonexistent
> service_id I get this error:

> ERROR:  cache lookup failed for type 37

Hmm.  Looks like exec_eval_expr should be more careful about setting
a result datatype when the expression returns no rows.  NULL is NULL,
but it still has a defined datatype ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: graphing time series data
Next
From: Mario Splivalo
Date:
Subject: CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification?