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