[pgadmin-support] pgadmin retrieving details about schema (700 objects) more than 5min

2012-04-20 Thread Radovan Jablonovsky
Hello, We are using PgAdmin version 1.14.2, running on Windows 7 Enterprise 64bit, 3.2GHz CPU with 4GB RAM to connect to postgres 9.1.1 linux x64 on centos 5.8 aspdata=# select version(); version

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Guillaume Lelarge
On Fri, 2012-04-20 at 17:09 -0400, Colin Beckingham wrote: > > On 04/20/2012 04:27 PM, Guillaume Lelarge wrote: > > On Fri, 2012-04-20 at 10:25 -0400, Colin Beckingham wrote: > >> > >> On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: > >>> Hi Colin, > >>> > >>> On Fri, 2012-04-20 at 13:15 +0200, G

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Colin Beckingham
On 04/20/2012 04:27 PM, Guillaume Lelarge wrote: On Fri, 2012-04-20 at 10:25 -0400, Colin Beckingham wrote: On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: Hi Colin, On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: On

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Guillaume Lelarge
On Fri, 2012-04-20 at 10:25 -0400, Colin Beckingham wrote: > > On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: > > Hi Colin, > > > > On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: > >> On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: > >>> > >>> On 04/11/2012 04:38 PM, Coli

Re: [pgadmin-support] Explain query

2012-04-20 Thread Guillaume Lelarge
On Fri, 2012-04-20 at 22:10 +0200, Bartosz Dmytrak wrote: > > 2012/4/20 Guillaume Lelarge > I tried on PostgreSQL 9.2dev, and I get the same error without > using > pgAdmin. So the problem is within PostgreSQL, not pgAdmin. I > only have > the error if I us

Re: [pgadmin-support] Explain query

2012-04-20 Thread Bartosz Dmytrak
2012/4/20 Guillaume Lelarge > I tried on PostgreSQL 9.2dev, and I get the same error without using > pgAdmin. So the problem is within PostgreSQL, not pgAdmin. I only have > the error if I use the VERBOSE option. EXPLAIN, and EXPLAIN ANALYZE > without verbose work great. So I guess you should com

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Colin Beckingham
On 04/20/2012 07:58 AM, Guillaume Lelarge wrote: Hi Colin, On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: On 04/11/2012 04:38 PM, Colin Beckingham wrote: Guillaume, I see the missing column name in index-properties has

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Guillaume Lelarge
Hi Colin, On Fri, 2012-04-20 at 13:15 +0200, Guillaume Lelarge wrote: > On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: > > > > On 04/11/2012 04:38 PM, Colin Beckingham wrote: > > > Guillaume, I see the missing column name in index-properties has been > > > fixed. Thanks. > > > > > > H

Re: [pgadmin-support] dev 1.15, wxw 2.9.3 - index column name truncated by 1 char

2012-04-20 Thread Guillaume Lelarge
On Wed, 2012-04-11 at 17:13 -0400, Colin Beckingham wrote: > > On 04/11/2012 04:38 PM, Colin Beckingham wrote: > > Guillaume, I see the missing column name in index-properties has been > > fixed. Thanks. > > > > However the column name appears to be truncated one char too early; > > bookid becomes

Re: [pgadmin-support] Explain query

2012-04-20 Thread Guillaume Lelarge
On Wed, 2012-04-18 at 22:51 +0200, Bartosz Dmytrak wrote: > Hi, > I faced strange problem (strange for me): > I have written code: > > WITH t as ( > INSERT INTO "tblD1" (id, "Data1") > VALUES ('a', 123) > RETURNING *) > > UPDATE "tblBase" > SET "SomeData" = 123 > WHERE id = 'a'; > > > this cod