PostgreSQL pg_connection_status() bug?

PostgreSQL pg_connection_status() bug?

am 08.12.2007 00:05:30 von scott

I found some quite odd today and I am wondering if anyone else has
encountered this (or can reproduce it) - or maybe I am just going crazy.

The function pg_connection_status() should return PGSQL_CONNECTION_BAD or
null if the PostgreSQL service/database has stopped/restarted/ is not
responding - after you have connected to it.

But what I encountered today suggests that is continues to return
PGSQL_CONNECTION_OK after the stop / restart. It will only start returning
PGSQL_CONNECTION_BAD if you try to run a query.

For example - this is what I am experiencing:

$link_id = pg_connect("dbname=test");

//do some queries ... etc ...

// pg_connection_status($link_id) equals PGSQL_CONNECTION_OK;

*** PostgreSQL database/service is stopped or restarted ***

// pg_connection_status($link_id) still equals PGSQL_CONNECTION_OK;

pg_query($link_id,$query); // this fails - outputs an error

// pg_connection_status($link_id) now equals PGSQL_CONNECTION_BAD or null;

Any comments or suggestions would be appreciated. Thanks.

Scott

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php