[Help-smalltalk] Postgres and blocked poll

[Holger Hans Peter Freyther]

Hi Paolo,

I have one more issue with the Postgres DBI driver. In case of the VPN
vanishing (or suspend/resume my laptop) the next database query will call
PQgetResult which will block in poll forever.

According to the Postgres documentation one can get the socket from the
connection, use the PQconsumeInput to make PQ read it and there is something
like PQisbusy.

Now the question is how to integrate this. Whenever executing a query I could
greate a FileDescriptor, wait until it is readable, call PQconsumeInput..

[
   PQisBusy..
] whileFalse: [
   (FileDescriptor on: connection socket) ensureReadable.
   PQConsumeInput..
].

Does this sound okay? This would just leave the issue when connecting.