psql close

Hi all,

I've been using the libpq asynchronous functions to hook up database
calls into my event loop, and I've noticed a problem and was hoping
someone might know the solution.

The problem is that I have to unregister the file descriptor from the
event loop whenever the postgres connection fails, but often by the
time I notice it has failed in the code, it has already closed its
socket and so I can't guarantee that if I close the previously opened
socket that it hasn't already been opened up by someone else.

Maybe an example will make it clearer:

void send_to_db(PGConn *conn, char *command)
{   PQsendQuery(conn, command);
   if (PQstatus(conn) == CONNECTION_BAD) {       Log(WARNING, "database connection disconnected");
       /* By this point PQsocket() returns -1. Even if I keep a
reference to the socket number        * it might have already been opened by another socket call. */
PQfinish(conn);
       /* Call function to reconnect, but I should have already
deleted the file event callbacks for the postgres connection socket.
*/   }
}

Please let me know what the solution is, or if something isn't clear.

Thanks,

Tony