Postgres Pro
Downloads
Home   >   mailing lists

Re: cursor "" already in use - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: cursor "" already in use
Date
Msg-id 20050902131211.GA65202@winnie.fuhr.org
Whole thread Raw
In response to cursor "" already in use  (Stathis Stergou <stathisstergou@yahoo.gr>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Stathis Stergou
Date:
Subject: cursor "" already in use
Next
From: Jerome Alet
Date:
Subject: not sure about constraints