Re: API like mysql_ping

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: API like mysql_ping
Date: 2005-08-25 13:41:54
Message-ID: fd3e7e50f5be63093ae2be34b3948452@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>> PQstatus perhaps?
>>
>> http://www.postgresql.org/docs/8.0/interactive/libpq-status.html

> This only returns the last status, not the current.
> pgAdmin uses SELECT 1 for this.

Better still: PQtransactionStatus, followed by a quick
PQexec of "SELECT 'pingtest' if it returns PQTRANS_IDLE.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200508250940
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkMNymsACgkQvJuQZxSWSsjm2gCgt+4pdyd5GiFjyJeDqNSbR14C
svMAn0OxrtEqcFgDruogLdmhvavokdSb
=nist
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-08-25 13:53:32 Re: TODO list comments
Previous Message Andrew Dunstan 2005-08-25 13:30:49 Re: [HACKERS] Proposed patch to getaddrinfo.c to support