From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Evan Martin <postgresql(at)realityexists(dot)net> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Prevent loss of query text when pgAdmin crashes or freezes |
Date: | 2012-07-02 20:44:29 |
Message-ID: | 1341261869.1912.41.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-07-02 20:46:49 | Re: default parameters |
Previous Message | Andrey Vinogradov | 2012-07-02 11:04:31 | default parameters |