Bug #523: ERROR: fmgr_info: function 19053: cache lookup failed
Kris Anderson (vanish1024@onebox.com) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
ERROR: fmgr_info: function 19053: cache lookup failed
Long Description
pgSQL information -
PostgreSQL 7.1.3 on i386--freebsd4.4, compiled by GCC 2.95.3
I've tried even the simplest of programs and still get the error.
in following some of the examples for the plpgsql language the server responds with the Short Description error message.
Sample Code
CREATE FUNCTION test(text)
RETURNS text
AS 'DECLARE
str text;
BEGIN
str := ''Hi'';
RETURN str;
END;'
LANGUAGE 'plpgsql';
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
ERROR: fmgr_info: function 19053: cache lookup failed
It looks like your declaration for the plpgsql language is messed up;
specifically, the pg_language row is there but the underlying handler
function has been deleted. I'd suggest dropping and re-adding the
language --- see droplang and createlang scripts.
regards, tom lane