Well I fix problem with this patch (I try connect once again after PQreset())

--- dbpgsql.c.dist    Fri Aug 19 18:30:42 2005
+++ dbpgsql.c    Fri Sep 30 16:16:16 2005
@@ -91,8 +91,11 @@
    if (PQstatus(conn) == CONNECTION_BAD) {
        PQreset(conn);
        if (PQstatus(conn) == CONNECTION_BAD) {
- trace(TRACE_ERROR, "%s,%s: connection with database gone bad", __FILE__, __func__);
+            if(db_connect() != 0)
+            {
+ trace(TRACE_ERROR, "%s,%s: connection with database gone bad (server says: %s)", __FILE__, __func__, PQerrorMessage(conn));
            return -1;
+            }
        }
} return 0;

Reply via email to