Thread: pgadmin 1.6 Beta 2 crashes

pgadmin 1.6 Beta 2 crashes

From
"Dennis, EBAY #1"
Date:
- Windows XP SP2 Professional
- english
- binary distribution -> version 1.6 Beta 2


1) Open PGADMIN, Going to 'View', clicking on 'System Objects', I get a dialog saying 'System objects will not show in the object tree until a refresh is performed. Close all connections now?' -> click on Yes; repeat (unselecting 'System Objects') and PgAdmin crashes.

2) Open PGADMIN, Going to 'View', clicking on 'System Objects', I get a dialog saying 'System objects will not show in the object tree until a refresh is performed. Close all connections now?' -> click on Yes; close PgAdmin (hitting X) and PgAdmin crashes.

Re: pgadmin 1.6 Beta 2 crashes

From
"Dave Page"
Date:
 


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dennis, EBAY #1
Sent: 06 October 2006 04:24
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgadmin 1.6 Beta 2 crashes

- Windows XP SP2 Professional
- english
- binary distribution -> version 1.6 Beta 2


1) Open PGADMIN, Going to 'View', clicking on 'System Objects', I get a dialog saying 'System objects will not show in the object tree until a refresh is performed. Close all connections now?' -> click on Yes; repeat (unselecting 'System Objects') and PgAdmin crashes.

2) Open PGADMIN, Going to 'View', clicking on 'System Objects', I get a dialog saying 'System objects will not show in the object tree until a refresh is performed. Close all connections now?' -> click on Yes; close PgAdmin (hitting X) and PgAdmin crashes.

Thanks, I've committed a fix that appers to fix this (it was a bit of a strange bug).
 
Regards, Dave.

Re: pgadmin 1.6 Beta 2 crashes

From
"Dave Page"
Date:
 


From: Dennis, EBAY #1 [mailto:ccweb03@yahoo.com]
Sent: 07 October 2006 08:51
To: Dave Page
Subject: Re: [pgadmin-support] pgadmin 1.6 Beta 2 crashes

Couple more things after testing (this time I used Windows 2000 Pro SP4)

- dialog window for an constraint creation remembers its position if it's moved/opened/closed. The problem is that if resolution on the monitor is reduced, the dialog window falls out of the resolution range (displayed too much to the right or bottom) and if you open it, you cannot see it and PgAdmin becomes affectively locked. (same issue with other nested dialog windows such as the dialog box for adding a column to a table etc) 
 
I've committed a change to ensure CheckOnScreen() is called during dialogue creation. This should solve the issue.
 

- user defined types cannot be chosen as a column during creation of a table but domains can? 
 
It was excluding composite types as they are commonly the base types for table rows. I've committed a change to include them, where the pg_class entry is flagged specifically as a composite type and not a row type.
 

- what's an 'unknown' data type?
 
 
Exactly what it sounds like :-). Also now supressed in pgAdmin.
 
- double clicking on an object opens its property dialog box but the box it not focused by default -> this is somewhat annoying as you cannot close the dialog box by simply clicking escape and at the same time if you do want to use the property box you have to click on it for it to gain focus first 
 
 
Unfortunately it seems that the treeview control grabs focus back after firing the event that we use to open the dialogue. I'm not sure how we could work around this.
 

- as a feature, it would be nice to be able hide Aggregates, Conversions, Operators etc as those are rarely used -> a properties box where the user can select which items to show in the schema tree would be nice

Yes, however this will have to wait for the next version.
 
Thanks for the feedback.
 
Regards, Dave. 

Re: pgadmin 1.6 Beta 2 crashes

From
"Ezequias Rodrigues da Rocha"
Date:
I am having problems with beta 2. I am thinking to came back to Beta 1. It crashes on simple queries. It mounts the grid on the botton but no data, after it pgAdmin crashes.

What big modification you did to cause this instability.


Sincerely
Ezequias

2006/10/9, Dave Page <dpage@vale-housing.co.uk>:
 


From: Dennis, EBAY #1 [mailto:ccweb03@yahoo.com]
Sent: 07 October 2006 08:51
To: Dave Page
Subject: Re: [pgadmin-support] pgadmin 1.6 Beta 2 crashes

Couple more things after testing (this time I used Windows 2000 Pro SP4)

- dialog window for an constraint creation remembers its position if it's moved/opened/closed. The problem is that if resolution on the monitor is reduced, the dialog window falls out of the resolution range (displayed too much to the right or bottom) and if you open it, you cannot see it and PgAdmin becomes affectively locked. (same issue with other nested dialog windows such as the dialog box for adding a column to a table etc) 
 
I've committed a change to ensure CheckOnScreen() is called during dialogue creation. This should solve the issue.
 

- user defined types cannot be chosen as a column during creation of a table but domains can? 
 
It was excluding composite types as they are commonly the base types for table rows. I've committed a change to include them, where the pg_class entry is flagged specifically as a composite type and not a row type.
 

- what's an 'unknown' data type?
 
 
Exactly what it sounds like :-). Also now supressed in pgAdmin.
 
- double clicking on an object opens its property dialog box but the box it not focused by default -> this is somewhat annoying as you cannot close the dialog box by simply clicking escape and at the same time if you do want to use the property box you have to click on it for it to gain focus first 
 
 
Unfortunately it seems that the treeview control grabs focus back after firing the event that we use to open the dialogue. I'm not sure how we could work around this.
 

- as a feature, it would be nice to be able hide Aggregates, Conversions, Operators etc as those are rarely used -> a properties box where the user can select which items to show in the schema tree would be nice

Yes, however this will have to wait for the next version.
 
Thanks for the feedback.
 
Regards, Dave. 



--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Re: pgadmin 1.6 Beta 2 crashes

From
"Dave Page"
Date:
 


From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 09 October 2006 19:47
To: Dave Page
Cc: Dennis, EBAY #1; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgadmin 1.6 Beta 2 crashes

I am having problems with beta 2. I am thinking to came back to Beta 1. It crashes on simple queries. It mounts the grid on the botton but no data, after it pgAdmin crashes.

What big modification you did to cause this instability. 

 
The only changes to the query tool were:
 
Improve default sizing of toolbars on OSX
Ensure pane captions get reset to the localised version correctly, per Guillaume
Fix save prompt default, per AgentM
Fix attention grabber, per AgentM 
You might try selecting the 'Default View' option from the View Menu in case something got
incompatibly changed in your view settings. If that doesn't work, we need more details please:
platform, what exactly you did at hte time of the crash etc.
FWIW though, I've been using the SVN trunk code daily without issues with some quite 
complex queries.
Regards, Dave.

pgAdmin 1.6 Beta 2 query crashes on windows

From
"George Pavlov"
Date:
PgAdmin III Query 1.6 Beta 2 is pretty unusable to me (WinXP SP2, stock
US install) -- it crashes fairly regularly upon query submission and I
end up losing a lot of my edits. FWIW, in 99% of the times I submit
queries by highlighting using keyboard + F5. No particular pattern of
usage causes this, just some up and down in the query edit pane, maybe
some clicking in the result-set grid, and query submission. Usually it
happens several queries into my interaction with pgAdmin (it has NEVER
happened on the first query submitted). Not sure what else to report,
but I will be reverting back to the old version because I lose too much
work from crashes this way.

I have saved some of the Windows output ("Do you want to send your
information to MS?" dialogs) if anyone thinks they may be useful I can
email.

George


Re: pgAdmin 1.6 Beta 2 query crashes on windows

From
"Dave Page"
Date:

> -----Original Message-----
> From: George Pavlov [mailto:gpavlov@mynewplace.com]
> Sent: 12 October 2006 22:23
> To: pgadmin-support@postgresql.org
> Cc: Dave Page
> Subject: pgAdmin 1.6 Beta 2 query crashes on windows
>
> PgAdmin III Query 1.6 Beta 2 is pretty unusable to me (WinXP
> SP2, stock
> US install) -- it crashes fairly regularly upon query submission and I
> end up losing a lot of my edits. FWIW, in 99% of the times I submit
> queries by highlighting using keyboard + F5. No particular pattern of
> usage causes this, just some up and down in the query edit pane, maybe
> some clicking in the result-set grid, and query submission. Usually it
> happens several queries into my interaction with pgAdmin (it has NEVER
> happened on the first query submitted). Not sure what else to report,
> but I will be reverting back to the old version because I
> lose too much
> work from crashes this way.
>
> I have saved some of the Windows output ("Do you want to send your
> information to MS?" dialogs) if anyone thinks they may be useful I can
> email.

George,

Please try beta 3
(http://developer.postgresql.org/ftpsite/pgadmin3/release/v1.6.0-beta3/)
. I've made some changes that will hopefully solve this issue.

Regards, Dave.


Re: pgAdmin 1.6 Beta 2 query crashes on windows

From
"George Pavlov"
Date:
Dave,

It still crashes upon query submittal. I see no difference from beta2 in
this aspect.

George


> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Page
> Sent: Friday, October 13, 2006 12:14 AM
> To: George Pavlov; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAdmin 1.6 Beta 2 query
> crashes on windows
>
>
>
> > -----Original Message-----
> > From: George Pavlov [mailto:gpavlov@mynewplace.com]
> > Sent: 12 October 2006 22:23
> > To: pgadmin-support@postgresql.org
> > Cc: Dave Page
> > Subject: pgAdmin 1.6 Beta 2 query crashes on windows
> >
> > PgAdmin III Query 1.6 Beta 2 is pretty unusable to me (WinXP
> > SP2, stock
> > US install) -- it crashes fairly regularly upon query
> submission and I
> > end up losing a lot of my edits. FWIW, in 99% of the times I submit
> > queries by highlighting using keyboard + F5. No particular
> pattern of
> > usage causes this, just some up and down in the query edit
> pane, maybe
> > some clicking in the result-set grid, and query submission.
> Usually it
> > happens several queries into my interaction with pgAdmin
> (it has NEVER
> > happened on the first query submitted). Not sure what else
> to report,
> > but I will be reverting back to the old version because I
> > lose too much
> > work from crashes this way.
> >
> > I have saved some of the Windows output ("Do you want to send your
> > information to MS?" dialogs) if anyone thinks they may be
> useful I can
> > email.
>
> George,
>
> Please try beta 3
> (http://developer.postgresql.org/ftpsite/pgadmin3/release/v1.6
> .0-beta3/)
> . I've made some changes that will hopefully solve this issue.
>
> Regards, Dave.
>