[HACKERS] API like mysql_ping

2005-08-25 Thread Sivakumar K 








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

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

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 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 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 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