Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux