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@unixarea.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)