Re: refcursor - Mailing list pgsql-general

From Tom Lane
Subject Re: refcursor
Date
Msg-id 25573.1041883750@sss.pgh.pa.us
Whole thread Raw
In response to Re: refcursor  (Renê Salomão <rene@ibiz.com.br>)
List pgsql-general
>> sport=# select stat();
>> ERROR:  fmgr_info: function 16556: cache lookup failed

Does *any* plpgsql function work?  I think you probably broke plpgsql by
deleting its handler function, or something like that.  Try dropping and
recreating the plpgsql language (then you'll need to recreate your
function, too).

7.3 contains interlocks to prevent this sort of mistake, btw.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: [pgsql-advocacy] www.postgresql.org
Next
From: Peter Choe
Date:
Subject: Re: how to view stored procedures and triggers