Thread: crash while creating table

crash while creating table

From
Julius Tuskenis
Date:
Hello List,

pgAdmin 1.14 beta2
Windows XP SP3

Connecting to PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc 
(Gentoo 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2

pgAdmin crashes when creating new table.

Steps to reproduce
1. Connect to server
2. Select DB, schema, tables
3. Select New table from popup menu (Tool button works too)
4. Enter table name in dialog
5. Select SQL page
6. Observe the crash

The same happens if you enter all fields you like and then hit ok 
button. I guess the SQL generating procedure is to blame...

NOTE: This happens on 8.3.4 server. When I try to reproduce it on 
PostgreSQL 9.0.3, compiled by Visual C++ build 1500, 32-bit on localhost 
I get no error.

Feel free to ask for additional information. I'll be happy to help.

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



Re: crash while creating table

From
Dave Page
Date:
On Fri, Jul 15, 2011 at 9:19 AM, Julius Tuskenis <julius@nsoft.lt> wrote:
> Hello List,
>
> pgAdmin 1.14 beta2
> Windows XP SP3
>
> Connecting to PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc
> (Gentoo 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2
>
> pgAdmin crashes when creating new table.
>
> Steps to reproduce
> 1. Connect to server
> 2. Select DB, schema, tables
> 3. Select New table from popup menu (Tool button works too)
> 4. Enter table name in dialog
> 5. Select SQL page
> 6. Observe the crash
>
> The same happens if you enter all fields you like and then hit ok button. I
> guess the SQL generating procedure is to blame...
>
> NOTE: This happens on 8.3.4 server. When I try to reproduce it on PostgreSQL
> 9.0.3, compiled by Visual C++ build 1500, 32-bit on localhost I get no
> error.

I can't reproduce this on the latest code from the 1.14 branch, using
8.3.15. Are you able to test the tip of that branch?


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: crash while creating table

From
Julius Tuskenis
Date:
On 2011.07.15 12:19, Dave Page wrote:
> I can't reproduce this on the latest code from the 1.14 branch, using
> 8.3.15. Are you able to test the tip of that branch?
Sorry Dave, I don't have means to compile pgAdmin. If you provided me 
with a binnary I would test it and report result back to the list.

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



Re: crash while creating table

From
Guillaume Lelarge
Date:
On Fri, 2011-07-15 at 13:20 +0300, Julius Tuskenis wrote:
> On 2011.07.15 12:19, Dave Page wrote:
> > I can't reproduce this on the latest code from the 1.14 branch, using
> > 8.3.15. Are you able to test the tip of that branch?
> Sorry Dave, I don't have means to compile pgAdmin. If you provided me 
> with a binnary I would test it and report result back to the list.
> 

This bug has been fixed on July, 2nd (so after beta2, but before beta3).
See
https://github.com/postgres/pgadmin3/commit/46bb9e4c66947cc8edfe853c1506ceeb470f475e for details.

So, you just need to grab beta 3.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: crash while creating table

From
Julius Tuskenis
Date:
On 2011.07.15 13:32, Guillaume Lelarge wrote:
> This bug has been fixed on July, 2nd (so after beta2, but before beta3).
> See
> https://github.com/postgres/pgadmin3/commit/46bb9e4c66947cc8edfe853c1506ceeb470f475e  for details.
Thank You for information (and the fix). I can confirm the problem is 
gone with beta3.

I have a proposal that is indirectly connected to this issue: could you 
please announce the release of betas in "Latest news" section in 
pgAdmin.org. This way more users would know when betas appear in 
download locations to test it and help improve the quality of this great 
peace of software.

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



Re: crash while creating table

From
Guillaume Lelarge
Date:
On Fri, 2011-07-15 at 14:08 +0300, Julius Tuskenis wrote:
> On 2011.07.15 13:32, Guillaume Lelarge wrote:
> > This bug has been fixed on July, 2nd (so after beta2, but before beta3).
> > See
> > https://github.com/postgres/pgadmin3/commit/46bb9e4c66947cc8edfe853c1506ceeb470f475e  for details.
> Thank You for information (and the fix). I can confirm the problem is 
> gone with beta3.
> 
> I have a proposal that is indirectly connected to this issue: could you 
> please announce the release of betas in "Latest news" section in 
> pgAdmin.org. This way more users would know when betas appear in 
> download locations to test it and help improve the quality of this great 
> peace of software.
> 

Yeah, we could probably do better in communication. We usually have a
beta each time PostgreSQL have one. But I agree that's not enough. We
should send announcement emails and put the announcement on the website.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com