Dave Page wrote:
>
>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