From ddee00da0e1a1ee8b3fef9b38844a6f902935874 Mon Sep 17 00:00:00 2001 From: Yasuo Ohgaki Date: Thu, 24 Jan 2002 06:20:33 +0000 Subject: No more httpd restart is required when PostgreSQL is rebooted. # Works for pg_query()/pg_send_query() --- ext/pgsql/pgsql.c | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'ext/pgsql') diff --git a/ext/pgsql/pgsql.c b/ext/pgsql/pgsql.c index 30dceb3f2c..fe802a28de 100644 --- a/ext/pgsql/pgsql.c +++ b/ext/pgsql/pgsql.c @@ -829,6 +829,9 @@ PHP_FUNCTION(pg_query) ZEND_FETCH_RESOURCE2(pgsql, PGconn *, pgsql_link, id, "PostgreSQL link", le_link, le_plink); + if (PQstatus(pgsql) != CONNECTION_OK) { + PQreset(pgsql); + } convert_to_string_ex(query); PQsetnonblocking(pgsql, 0); while ((pgsql_result = PQgetResult(pgsql))) { @@ -2510,6 +2513,9 @@ PHP_FUNCTION(pg_send_query) ZEND_FETCH_RESOURCE2(pgsql, PGconn *, &pgsql_link, id, "PostgreSQL link", le_link, le_plink); + if (PQstatus(pgsql) != CONNECTION_OK) { + PQreset(pgsql); + } if (PQsetnonblocking(pgsql, 1)) { php_error(E_NOTICE,"%s() cannot set connection to nonblocking mode", get_active_function_name(TSRMLS_C)); -- cgit v1.2.1