Thread: Bug #523: ERROR: fmgr_info: function 19053: cache lookup failed
Bug #523: ERROR: fmgr_info: function 19053: cache lookup failed
From
pgsql-bugs@postgresql.org
Date:
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