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
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 |