Postgres Pro
Downloads
Home   >   mailing lists

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

From CLIFFORD ILKAY
Subject Re: Why am I getting a "cursor already in use" error?
Date
Msg-id 5.2.0.9.0.20031119020207.029b8260@localhost
Whole thread Raw
In response to Why am I getting a "cursor already in use" error?  (CLIFFORD ILKAY <postgres@dinamis.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: CLIFFORD ILKAY
Date:
Subject: Why am I getting a "cursor already in use" error?
Next
From: Stef
Date:
Subject: Re: Point-in-time data recovery - v.7.4