On Fri, May 18, 2012 at 8:18 AM, Chris Angelico <rosuav@xxxxxxxxx> wrote: > On Sat, May 19, 2012 at 12:09 AM, Vincenzo Romano > <vincenzo.romano@xxxxxxxxxxx> wrote: >> You said enough about PQstatus. So issuing a "blank" command seems to >> be a good idea. Possibly the only one. >> >> Well, a "ping" function trying to use the current "PGconn*" to ping >> the server would make a lot of sense, though. > > If it helps make your code clearer, you could send the query "/* ping > */", which would be parsed by the server as a comment. I've not > verified, but a recent thread here mentioned that /**/ comments > (unlike double-hyphen ones) get sent to the server, so you'll see it > in your logs. Or send the command: select 1; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
