Re: BUG #5504: cache lookup failed for function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jan Merka" <merka(at)highsphere(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5504: cache lookup failed for function
Date: 2010-06-13 23:49:27
Message-ID: 20283.1276472967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jan Merka" <merka(at)highsphere(dot)net> writes:
> After installing postgresql 8.4.4 from sources, I am getting an error
> ERROR: cache lookup failed for function 2071

> Test case:

> SELECT date '2010-01-01' + interval '1 month';
> ERROR: cache lookup failed for function 2071

Works for me:

psql (8.4.4)
Type "help" for help.

regression=# SELECT date '2010-01-01' + interval '1 month';
?column?
---------------------
2010-02-01 00:00:00
(1 row)

The error indicates a failure to fetch the pg_proc entry for
date_pl_interval, which might indicate system catalog corruption,
or it might mean there is something wrong with your postgres executable.
Can you do the command in other database(s) in the same installation?
What do you get from "select * from pg_proc where oid = 2071;" ?
(If nothing, also try it with enable_indexscan and enable_bitmapscan
turned off.)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jan Merka 2010-06-14 00:04:41 Re: BUG #5504: cache lookup failed for function
Previous Message Maxim Boguk 2010-06-13 23:20:40 Re: BUG #5503: error in trigger function with dropped columns