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.
Regards,
Evan