Thread: testing in ESQL/C if a CUSROR "foo" is open?

Hello,

Is there any way (without looking up the name in table 'pg_cursors') to see if a
cursor "foo" is still open?

Thanks

    matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

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