pgAdmin Query Tool hangs when working with GIS data

Поиск
Список
Период
Сортировка
От Michael Willekes
Тема pgAdmin Query Tool hangs when working with GIS data
Дата
Msg-id AANLkTik3kxgy8Hg74zj1-Cta1dD0GfZ8AfGTY7t=oZoZ@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgAdmin Query Tool hangs when working with GIS data
Список pgadmin-support
Hello,

I've run into a  the same issue described here:


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). 

It's probably not a common scenario, but it took me a while to find the issue, so I thought I'd mention it here... 

Regards,
Mike

В списке pgadmin-support по дате отправления:

Предыдущее
От: Mashuka
Дата:
Сообщение: Error when installing pgAdmin on Windows 7 x64
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgAdmin Query Tool hangs when working with GIS data