Bug #663: ERROR: SearchSysCache: Bad cache id 27

Started by PostgreSQL Bugs Listalmost 24 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

George (george@lota.net) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
ERROR: SearchSysCache: Bad cache id 27

Long Description
I have upgraded postgreSQL from 7.1.2 to the lastest 7.2.1. But I found that I cannot use the old user-defined functions.

I wrote these functions using plpgsql and i got the following error.

ERROR: SearchSysCache: Bad cache id 27

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #663: ERROR: SearchSysCache: Bad cache id 27

pgsql-bugs@postgresql.org writes:

ERROR: SearchSysCache: Bad cache id 27

Your plpgsql functions are trying to use the old (7.1) plpgsql.so.

regards, tom lane