Re: API like mysql_ping - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: API like mysql_ping
Date
Msg-id fd3e7e50f5be63093ae2be34b3948452@biglumber.com
Whole thread Raw
In response to Re: API like mysql_ping  (Andreas Pflug <pgadmin@pse-consulting.de>)
List 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@turnstep.com
PGP Key: 0x14964AC8 200508250940
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

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

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




pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: TODO questions
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: TODO list comments