Re: cursor "<unnamed portal 1>" already in use

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Stathis Stergou <stathisstergou(at)yahoo(dot)gr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: cursor "<unnamed portal 1>" already in use
Date: 2005-09-02 13:12:11
Message-ID: 20050902131211.GA65202@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jerome Alet 2005-09-02 13:23:56 not sure about constraints
Previous Message Stathis Stergou 2005-09-02 11:17:52 cursor "<unnamed portal 1>" already in use