Why am I getting a "cursor already in use" error?

From: CLIFFORD ILKAY <postgres(at)dinamis(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Why am I getting a "cursor already in use" error?
Date: 2003-11-19 03:42:32
Message-ID: 5.2.0.9.0.20031118223744.0299b0e8@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am trying to create a PL/PGSQL stored proc in PostgreSQL 7.3.2 on
Mandrake 9.1. I keep getting a "cursor already in use" error even though I
only open the cursor once, fetch using that cursor, and then close the
cursor when I am finished with it. Why is this happening? I have pasted the
code at <http://www.paste.msunix.org/index.php?view=3012>.

Regards,

Clifford Ilkay
Dinamis Corporation
3266 Yonge Street, Suite 1419
Toronto, Ontario
Canada M4N 3P6

Tel: 416-410-3326

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message CLIFFORD ILKAY 2003-11-19 07:05:18 Re: Why am I getting a "cursor already in use" error?
Previous Message Martijn van Oosterhout 2003-11-19 02:30:56 Re: performance problem