Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-26 Thread Guillaume Lelarge
Le 26/12/2010 01:57, Dave Page a écrit : > Seems like a bugfix, even if thd behaviour changes. > OK, then commited to both. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-25 Thread Dave Page
Seems like a bugfix, even if thd behaviour changes. On 12/25/10, Guillaume Lelarge wrote: > Le 23/12/2010 00:31, Dave Page a écrit : >> On Thu, Dec 23, 2010 at 12:05 AM, Guillaume Lelarge >> wrote: >>> Le 22/12/2010 10:26, Dave Page a écrit : On Wed, Dec 22, 2010 at 10:15 AM, Guillaume Lela

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-25 Thread Guillaume Lelarge
Le 23/12/2010 00:31, Dave Page a écrit : > On Thu, Dec 23, 2010 at 12:05 AM, Guillaume Lelarge > wrote: >> Le 22/12/2010 10:26, Dave Page a écrit : >>> On Wed, Dec 22, 2010 at 10:15 AM, Guillaume Lelarge >>> wrote: Le 22/12/2010 09:47, Dave Page a écrit : > Guillaume; do we have a limit

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-22 Thread Dave Page
On Thu, Dec 23, 2010 at 12:05 AM, Guillaume Lelarge wrote: > Le 22/12/2010 10:26, Dave Page a écrit : >> On Wed, Dec 22, 2010 at 10:15 AM, Guillaume Lelarge >> wrote: >>> Le 22/12/2010 09:47, Dave Page a écrit : Guillaume; do we have a limit on the size of data we'll store in the histor

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-22 Thread Guillaume Lelarge
Le 22/12/2010 10:26, Dave Page a écrit : > On Wed, Dec 22, 2010 at 10:15 AM, Guillaume Lelarge > wrote: >> Le 22/12/2010 09:47, Dave Page a écrit : >>> Guillaume; do we have a limit on the size of data we'll store in the >>> history file? We've seen 3 or 4 reports like this. >>> >> >> The Options

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-22 Thread Dave Page
On Wed, Dec 22, 2010 at 10:15 AM, Guillaume Lelarge wrote: > Le 22/12/2010 09:47, Dave Page a écrit : >> Guillaume; do we have a limit on the size of data we'll store in the >> history file? We've seen 3 or 4 reports like this. >> > > The Options dialog says yes (1024 characters). But, AFAICT from

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-22 Thread Guillaume Lelarge
Le 22/12/2010 09:47, Dave Page a écrit : > Guillaume; do we have a limit on the size of data we'll store in the > history file? We've seen 3 or 4 reports like this. > The Options dialog says yes (1024 characters). But, AFAICT from reading the source code, we don't use it :-/ I was sure we did. Wi

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-22 Thread Dave Page
Guillaume; do we have a limit on the size of data we'll store in the history file? We've seen 3 or 4 reports like this. On Tue, Dec 21, 2010 at 11:15 PM, Michael Willekes wrote: > Thanks for investigating. It was simple to workaround once I realized what > the problem was.  My only concern was th

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-21 Thread Michael Willekes
Thanks for investigating. It was simple to workaround once I realized what the problem was. My only concern was that I had inadvertently triggered the issue, and it was not obvious how to resolve/workaround it. If someone runs into a similar issue, hopefully a search will turn-up this thread. Mi

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-21 Thread Guillaume Lelarge
Le 20/12/2010 22:20, Guillaume Lelarge a écrit : > Le 20/12/2010 16:39, Michael Willekes a écrit : >> The history file is only 14 MB (4219 lines long) but the PostGIS geometry >> columns (auto-generated from a .SHP file) result in individual INSERT >> statements that are as much as 50 character

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-21 Thread Mohammadk485 Mohammadk485
stop my subscription message On 12/20/10, Guillaume Lelarge wrote: > Le 20/12/2010 16:39, Michael Willekes a écrit : >> The history file is only 14 MB (4219 lines long) but the PostGIS geometry >> columns (auto-generated from a .SHP file) result in individual INSERT >> statements that are as much

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-20 Thread Guillaume Lelarge
Le 20/12/2010 16:39, Michael Willekes a écrit : > The history file is only 14 MB (4219 lines long) but the PostGIS geometry > columns (auto-generated from a .SHP file) result in individual INSERT > statements that are as much as 50 characters long. > Is it possible to get the SQL query? by pr

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-20 Thread Michael Willekes
The history file is only 14 MB (4219 lines long) but the PostGIS geometry columns (auto-generated from a .SHP file) result in individual INSERT statements that are as much as 50 characters long. This file is used by the query tool since 1.12. Do you know which size > it was? > > > -- > Guill

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-17 Thread Guillaume Lelarge
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 > " > > Hardware: > - Window

[pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-17 Thread Michael Willekes
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 " Hardware: - Windows 7 64 bit, 2 GB Ram, 2.8 Ghz Tools: - PostgreSQL 9.0.1, compiled b