From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: testing in ESQL/C if a CUSROR "foo" is open? |
Date: | 2019-12-30 07:04:35 |
Message-ID: | 20191230070435.GA3350@c720-r342378 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2019-12-30 13:29:34 | Re: replace single char for string using regexp_replace |
Previous Message | Tom Lane | 2019-12-30 04:50:03 | Re: replace single char for string using regexp_replace |