From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Michael Willekes <mikewillekes(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin Query Tool hangs when working with GIS data |
Date: | 2010-12-17 22:25:23 |
Message-ID: | 4D0BE353.8050605@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | jak | 2010-12-18 02:03:02 | history feature on sql editor 1.12.1 |
Previous Message | Michael Willekes | 2010-12-17 21:08:16 | pgAdmin Query Tool hangs when working with GIS data |