OS 6.0 Sleep and spinning wheel with Postgresql

[Andy Hilton]

You might want to add in something like :

Do pgsql.$connectstatus() Returns ConnectStatus
If ConnectStatus<>kPgSqlConnectionOK
    If pgsql.$validref
        Do pgsql.$reset()    
   End If
End If

This is an amended version of my (amended) StudioWorks code !

Andy

On Aug 11, 2014, at 8:51 AM, ADJob <mats at adjob.se> wrote:

> Hi $all,
> 
> Using Studio 6.0.2 and Postgresql 9.1. And have about the same problem as with ODB. When the computer goes to sleep a ”spinning wheel” appear.
> 
> Note that the session is still alive so I get no error:
> 
> If pgsql.$state<>kSessionStateLoggedOn
> 	OK message  {logoff}
> 	Do login.$start
> End If
> 
> Note that I can TCPPing the server and this connection is alive. Though a ”spinning wheel” appear.
> 
> But I cannot interact with Postgresql. What is happening and how can I trap this ”broken connection” and reconnect?
> 
> Any clue appreciated.
> 
> Mats Olsson, ADJob Nordic AB, Sweden_____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com