Re: [GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

2009-05-01 Thread Tom Lane
Peter Geoghegan peter.geoghega...@gmail.com writes: I'm developing a PostgreSQL application for Windows CE 5 on a PDT/ PDA in C++/Qt, using Hiroshi Saito's libpq port for that platform. Since the connection is established over wi-fi, and wi-fi connectivity is often flaky, I feel that I have to

Re: [GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

2009-05-01 Thread Peter Geoghegan
Wow, a response from the famous Tom Lane to my lame problem :-) . What I'd try is a ping to the database server, and not initiate any libpq operation unless the server is answering pings.  If you get a failure due to connectivity loss midway through an operation, PQreset is appropriate then

[GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

2009-04-30 Thread Peter Geoghegan
Hello, I'm developing a PostgreSQL application for Windows CE 5 on a PDT/ PDA in C++/Qt, using Hiroshi Saito's libpq port for that platform. Since the connection is established over wi-fi, and wi-fi connectivity is often flaky, I feel that I have to fail gracefully to as great an extent as