Re: [pgadmin-support] Bug, New Column... window, data type typing

2011-11-03 Thread Julius Tuskenis
Hello, all On 2011.11.02 23:28, Guillaume Lelarge wrote: On Tue, 2011-11-01 at 12:39 -0400, Henry Drexler wrote: Issue --- For this new version (1.14) navigate to a table> right click on table> properties> go to tab 'columns'> add> place cursor in 'data type' In this versio

Re: [pgadmin-support] Bug, New Column... window, data type typing

2011-11-03 Thread Guillaume Lelarge
On Thu, 2011-11-03 at 09:17 +0200, Julius Tuskenis wrote: > Hello, all > > On 2011.11.02 23:28, Guillaume Lelarge wrote: > > On Tue, 2011-11-01 at 12:39 -0400, Henry Drexler wrote: > >> Issue > >> --- > >> For this new version (1.14) navigate to a table> right click on table> > >>

Re: [pgadmin-support] very slow when writing query to file

2011-11-03 Thread boris pezzatti
I tested after column types, and the colum that appears to create the very slow behaviour is of type boolean. Retrieving only 1 column for 3000 records delays at ca. 1 minute. Do you know any possible reason? On 11/02/2011 11:58 PM, Fernando Hevia wrote: On Tue, Nov 1, 2011 at 07:23, Guil

Re: [pgadmin-support] very slow when writing query to file

2011-11-03 Thread Guillaume Lelarge
On Thu, 2011-11-03 at 11:22 +0100, boris pezzatti wrote: > I tested after column types, and the colum that appears to create the > very slow behaviour is of type boolean. Retrieving only 1 column for > 3000 records delays at ca. 1 minute. > > Do you know any possible reason? > That's good to k

Re: [pgadmin-support] very slow when writing query to file

2011-11-03 Thread Guillaume Lelarge
On Thu, 2011-11-03 at 12:02 +0100, Guillaume Lelarge wrote: > On Thu, 2011-11-03 at 11:22 +0100, boris pezzatti wrote: > > I tested after column types, and the colum that appears to create the > > very slow behaviour is of type boolean. Retrieving only 1 column for > > 3000 records delays at ca.

Re: [pgadmin-support] very slow when writing query to file

2011-11-03 Thread boris pezzatti
great, thank you a lot Guillaume! Cheers, Boris On 11/03/2011 12:20 PM, Guillaume Lelarge wrote: On Thu, 2011-11-03 at 12:02 +0100, Guillaume Lelarge wrote: On Thu, 2011-11-03 at 11:22 +0100, boris pezzatti wrote: I tested after column types, and the colum that appears to create the very slo

Re: [pgadmin-support] very slow when writing query to file

2011-11-03 Thread Fernando Hevia
On Thu, Nov 3, 2011 at 08:20, Guillaume Lelarge wrote: > > OK, found it. We introduced some time ago a cache for type lookup. It > seems the boolean type doesn't make it to the cache. The patch is > commited. It should be available with the release of 1.14.1. > > Nice. Thanks for fixing this. Exce

Re: [pgadmin-support] Bug, New Column... window, data type typing

2011-11-03 Thread Henry Drexler
thank you for the feedback. On Wed, Nov 2, 2011 at 5:28 PM, Guillaume Lelarge wrote: > On Tue, 2011-11-01 at 12:39 -0400, Henry Drexler wrote: > > from enterprise db download > > 64 bit on ubuntu 10.04 lts > > > > for pgadmin 1.14.0 (sep 23 2011, rev: REL-1_14_0) > > PostgreSQL 9.1.1 on x86_64-un