El día viernes, diciembre 27, 2019 a las 06:55:22a. m. +0100, Matthias Apitz escribió:
>
> Hello,
>
> Is there any way (without looking up the name in table 'pg_cursors') to see if a
> cursor "foo" is still open?
>
I found this hint about 'pg_cursors' in stackoverflow:
https://stackoverflow.com/questions/51146931/postgres-finding-an-open-cursor-and-closing-it
But did no see how to code this in ESQL/C, something like:
EXEC SQL IF EXISTS(SELECT * FROM pg_cursors WHERE name = :cur) THEN CLOSE :cur;
Which does not work. And, what concerns me as well is how expensive such
test is before closing any cursor.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub