postgresql plugin: Don't do any SQL query when checking the connection.

First of all, this is not needed -- PQstatus() will correctly determine a
failed connection without that. Secondly, the "SELECT 42" that was used before
does not work, e.g. when querying PgBouncer (thanks to renchap for reporting
this on IRC!).

diff --git a/src/postgresql.c b/src/postgresql.c
index 6c9ab44e8b3379aff58dd9b0b7a4295e6b74876c..e3a66743464e46b917fe8e25c760c650a0037e27 100644 (file)
--- a/src/postgresql.c
+++ b/src/postgresql.c
@@ -371,9 +371,6 @@ static int c_psql_check_connection (c_psql_database_t *db)
                c_psql_connect (db);
        }
 
-       /* "ping" */
-       PQclear (PQexec (db->conn, "SELECT 42;"));
-
        if (CONNECTION_OK != PQstatus (db->conn)) {
                PQreset (db->conn);