Re: Problem close curser after rollback

El día miércoles, septiembre 30, 2020 a las 01:32:41p. m. +0000, Wiltsch,Sigrid escribió:

>  
> Hi, 
>
> we use the following statements in our applications, as described on the site:
>  
> https://www.postgresql.org/docs/11/ecpg-commands.html#ECPG-TRANSACTIONS
>  
> EXEC SQL PREPARE stmt1 FROM "SELECT oid,datname FROM pg_database WHERE oid > ?";
> EXEC SQL DECLARE foo_bar CURSOR FOR stmt1;
>  
> ...

I forgot to mention that the problem is with PostgreSQL 11.4 on SuSE
Linux Enterprise. If the problem is not clear, we could rewrite this as
a ten-liner in ESQL/C to reproduce it.

The OP (Sigrid) and me we're working in the same team.

Thanks

matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Без книги нет знания, без знания нет коммунизма (Влaдимир Ильич Ленин)
Without books no knowledge - without knowledge no communism (Vladimir Ilyich Lenin)
Sin libros no hay saber - sin saber no hay comunismo. (Vladimir Ilich Lenin)