Oliver Jowett <[EMAIL PROTECTED]> writes:
> Sivakumar K wrote:
>> Do we have an API like mysql_ping to check whether the server is up and
>> running after the connection has been established?
> At the protocol level, you could send Sync and wait for ReadyForQuery.
At the client level, the easiest
-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 "SE
Sivakumar K wrote:
> Do we have an API like mysql_ping to check whether the server is up and
> running after the connection has been established?
At the protocol level, you could send Sync and wait for ReadyForQuery.
-O
---(end of broadcast)---
TIP
Christopher Kings-Lynne wrote:
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.
Regards,
Andreas
---(end of broadcast)---
TIP
PQstatus perhaps?
http://www.postgresql.org/docs/8.0/interactive/libpq-status.html
Chris
Sivakumar K wrote:
Do we have an API like mysql_ping to check whether the server is up and
running after the connection has been established?
I checked the PostgreSQL docs but of no use.
Is there