On Sat, Sep 18, 2004 at 12:43:05PM -0400, Tom Lane wrote:
> I don't see any reason for guesswork. Remember the PID of the backend
> you were connected to. On reconnect, look in pg_stat_activity to see if
> that backend is still alive; if so, sleep till it's not. Then check to
> see if your transaction committed or not. No need for anything so
> dangerous as a timeout.
Looks like that only works if stats_command_string is set (and backend
version is at least 7.2), correct? I couldn't find this table in the
online documentation, but can I assume that the query will have finished
executing (whether for good or for bad) when its current_query is either
empty or null?
Jeroen