Re: refcursor

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Vecernik <vecernik(at)aon(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: refcursor
Date: 2003-01-06 20:09:10
Message-ID: 25573.1041883750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Choe 2003-01-06 20:16:23 Re: how to view stored procedures and triggers
Previous Message Gavin M. Roy 2003-01-06 20:05:17 Re: [GENERAL] www.postgresql.org