Le 17/12/2010 22:08, Michael Willekes a écrit : > Hello, > > I've run into a the same issue described here: > > "Query Tool history makes the Query Tool unusable after BIG query had been > executed<http://archives.postgresql.org/pgadmin-support/2010-09/msg00006.php> > " > > Hardware: > - Windows 7 64 bit, 2 GB Ram, 2.8 Ghz > > Tools: > - PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 32-bit > - pgAdmin 1.12.1 (Oct 3, 2010, rev:REL-1_12_1) > - PostGIS 1.5.2 > > I used shp2pgsql from the PostGIS toolkit to generate an SQL Query from a > shapefile(*). The generated .SQL file is not too big (~13MB) but is a > little odd in that some of the generated geometry columns are excessively > wide (>250K characters on a single line). The query executes fine (data is > correctly loaded into the database), but subsequent attemps to load the > pgAdmin query tool cause pgAdmin to hang (has to be killed from Task > Manager). > > Deleting 'pgadmin_histoqueries.xml' resolves the issue. I > uninstalled/reinstalled pgAdmin several times, but didn't know about the > existance of this history file (which was stored in my Windows AppData Dir - > and 'survived' an uninstall/reinstall - which of course meant that each > install exhibited the same problem). >
This file is used by the query tool since 1.12. Do you know which size it was? -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
