Обсуждение: 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