
> > As I wrote it before there, it is an ECPG script that runs with bad perfs.
> > ...
> > it seems that on every commit, the cursor is closed
> 
> Cursors shouldn't be closed, but prepared statements are deallocated on each
> commit. AFAIK this is what the standard says.

Wow, this sure sounds completely bogus to me. 
Imho CURSORS opened inside a transanction (after BEGIN WORK) are supposed to
be closed (at least with autocommit=yes).  

I do not think COMMIT is supposed to do anything with a prepared 
statement. That is what EXEC SQL FREE :statementid is for.

That would then match e.g. Informix esql/c.

Andreas

Fri, 1 Mar 2002 12:34:08 +0100
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: Oracle vs PostgreSQL in real life