X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4596CD7868
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Sep 2005 10:12:16 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 17098-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Sep 2005 13:12:13 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id 1AA9BD7839
	for <pgsql-sql@postgresql.org>; Fri,  2 Sep 2005 10:12:12 -0300 (ADT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j82DCC3V029051
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Fri, 2 Sep 2005 07:12:14 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j82DCBu1065279;
	Fri, 2 Sep 2005 07:12:12 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j82DCBmh065278;
	Fri, 2 Sep 2005 07:12:11 -0600 (MDT) (envelope-from mfuhr)
Date: Fri, 2 Sep 2005 07:12:11 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Stathis Stergou <stathisstergou@yahoo.gr>
Cc: pgsql-sql@postgresql.org
Subject: Re: cursor "<unnamed portal 1>" already in use
Message-ID: <20050902131211.GA65202@winnie.fuhr.org>
References: <431834E0.5010802@yahoo.gr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <431834E0.5010802@yahoo.gr>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005]
X-Spam-Level: 
X-Archive-Number: 200509/11
X-Sequence-Number: 22558

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