PgAdmin sometimes crash when clicking SQL query button

Question

I know this question may be seen as a duplicate with this one. I even have almost the same configuration (PostgreSQL 9.1.3, pgAdmin III 1.14.3, 32 bit Windows). What is the difference and the reason I ask a new question is that my PgAdmin doesn't crash always (just mostly) and that the cause of the problem is different - in linked question the problem was with missing adminpack, but I have adminpack installed and it works well, so the answer for linked question doesn't work for me.

Do you have any ideas where the problem could be?

EDIT: PgAdmin doesn't crash at other occasions (well, unless I do someting that obviously deserves a crash), just while trying to open SQL query window. It's worse and worse as time goes on, now it's almost "always". The problem is not "connection specific" - frequence of crashing is the same for different server connections.

EDIT2: I reinstalled PgAdmin and nothing have changed. I'm starting to suspect PostgreSQL 9.1.3 or even PostGIS 2.0.1 of the problem.

Answer 1

PgAdmin crashes on me all of the time, but you eventually learn to be gentle with it.

Particularly, if it is waiting for a response from the PostgreSQL server, the window may freeze up until a reply is returned and parsed. When this happens, do not close the window, just wait.

Also, if you attempt to edit two different objects on the same parent, save one and click save on the other, this crashes the program.

My advice would be to only do one thing at a time, be patient, and don't be in a hurry to kill the process when it freezes up.

Answer 2

1. Goto run and type %appdata% and go inside postgresql folder.
2. rename or delete pgadmin_histoqueries.xml file.
3. try opening the SQL query editor again.

Good luck!