Anyway, the reason I posted the patch was to gather ideas and feedback,
not to propose it as a final solution (as your initial comments indicate
you thought). I don't see any way to implement this cleanly at this
layer now so unless you or anyone else has any bright ideas I'll scrub
it from the todo list as unworkable, and move one...
pgAdmin3 is just another app, concerning the database connection. So if pgAdmin3 suffers from broken links, any other libpq app would too. It would make sense to implement this in libpq.
If we wanted to implement this in pgAdmin3, we'd need a global keepalive thread, scanning all connections if a keep alive query is needed, interlocking with a semaphor to prevent interference with wanted queries. This thread also could silently handle reconnects.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
