Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Tom Lane 
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 thing is probably to execute an empty
query string.

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Greg Sabino Mullane 

-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 [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200508250940
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-BEGIN PGP SIGNATURE-

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



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Oliver Jowett 
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 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Andreas Pflug 

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 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Christopher Kings-Lynne 

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 any work around for this?

 


/*/ Regards, /*/

/*/ Siva Kumar.K /*/

 



---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly