Re: Prevent loss of query text when pgAdmin crashes or freezes

On Mon, 2012-07-02 at 12:32 +1000, Evan Martin wrote:
> I often have multiple SQL query windows open in pgAdmin (v1.14.3 on 
> Windows 7 x64). From time to time pgAdmin will crash or freeze (become 
> unresponsive) and would have to be killed. When this happens all unsaved 
> query text is lost, which is extremely frustrating. It's by far the 
> biggest problem for me in using pgAdmin.
> 
> Please implement some way to recover the query text from such crashes. 
> Ideally something like what Firefox or Chrome do: when restarted after a 
> crash they offer the option to restore previous windows (including form 
> data, at least in Chrome). This would require that pgAdmin saves query 
> text in the background on a regular basis (at least before running any 
> query).
> 
> Another great way to mitigate this would be to run each SQL query window 
> in a separate process, so it could crash without bringing down the rest. 
> However, the main pgAdmin process could crash, too, and this should not 
> kill the query window processes without allowing data to be saved.
> 

I though we already had this in our TODO list, but I can't find it. So I
added it.

Thanks for the idea.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com