Re: cursor "" already in use

On Fri, Sep 02, 2005 at 02:17:52PM +0300, Stathis Stergou wrote:
> ERROR:  cursor "<unnamed portal #a number here#>" already in use
> CONTEXT:  PL/pgSQL function "bufferfeatures" line 19 at open

You're trying to open a cursor that's already open.  Close the
cursor at the end of the loop in which you opened it, so that it
gets closed before you try to open it again on the next loop
iteration.

-- 
Michael Fuhr