Postgres Pro
Downloads
Home   >   mailing lists

Why am I getting a "cursor already in use" error? - Mailing list pgsql-admin

From CLIFFORD ILKAY
Subject Why am I getting a "cursor already in use" error?
Date
Msg-id 5.2.0.9.0.20031118223744.0299b0e8@localhost
Whole thread Raw
Responses Re: Why am I getting a "cursor already in use" error?
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Replicate PostgreSQL with rsync
Next
From: CLIFFORD ILKAY
Date:
Subject: Re: Why am I getting a "cursor already in use" error?