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@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
