Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
CLIFFORD ILKAY
Date:
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

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

From
CLIFFORD ILKAY
Date:
At 22:42 18/11/2003 -0500, CLIFFORD ILKAY wrote:
>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>.

Never mind. I was invoking the stored procedure incorrectly.

Incorrect:

select fx_extract_email_address('1111') from people;

Correct:
select * from fx_extract_email_address('1111');

Regards,

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

Tel: 416-410-3326