Horton

Re: USE OF CURSORS IN ECPG

Michael Meskes <meskes@postgresql.org>

View thread
From: Michael Meskes <meskes@postgresql.org>
To: Maurizio <maurizio@dreamtech-it.com>
Cc: pgsql-interfaces@postgresql.org
Date: 2000-11-08T11:39:42Z
Lists: pgsql-hackers 
On Tue, Nov 07, 2000 at 05:52:00PM +0100, Maurizio wrote:
> I'm just starded using ecpg and I have some problem with cursors.
> ...
>     exec sql prepare stmtunimpianto from :query;
>     .
>     .
>     exec sql commit;
> ...
> If I rem the commit all works fine but if I execute the commit the cursor was deleted and I receive some errors.
> 
> At open cursor : sqlca.sqlcode = -230 Invalid statement namei in line ......
> at fetch           : NOTICE : PerformPortalFetch: portal "cur_unimpianto" not found

No surprise here as ending a transaction forces a deallocation of all
prepared statements. AFAIK that's what the standard says.

Michael

-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!