Unix Technical Forum

pgAdmin beta 3 query bug

This is a discussion on pgAdmin beta 3 query bug within the pgsql Interfaces Pgadmin Hackers forums, part of the PostgreSQL category; --> Hi Mike, George, I've been looking some more at this bug you are both experiencing. From what I recall, ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 07:23 PM
Dave Page
 
Posts: n/a
Default pgAdmin beta 3 query bug

Hi Mike, George,

I've been looking some more at this bug you are both experiencing. From
what I recall, George is seeing it in the Query Tool, whilst Mike is
seeing it in the Edit Grid. I've seen another report for each from
Ezequias and Harald.

Both tools share two important pieces of code:

1) ctlSqlGrid is our custom control that is based on wxGrid and is used
to display the results. This code is primarily used to size rows/columns
and extract data (ie. When exporting). Most of the real work is done by
wxGrid which we've used since 1.0.

2) pgQueryThread. This is a class that is used to run a query
asynchronously. It is this class that I fixed a couple of bugs in for
beta 3 that had demonstrably caused crashes for me.

I suspect that the problem that remains is an issue in the wxWidgets
code as pgQueryThread is fairly simple and there is little else to go
wrong in it that I can spot. I did find a seemingly unrelated threading
bug in wx right before beta 3 which I was forced to workaround, however
I found today that wxWidgets 2.7.1 has been released, in which that bug
appears to have been fixed.

So, before I go insane trying to track this down further, may I send you
both an updated .exe built against wx2.7.1, in the hope that we've
actually been seeing just one bug that's manifested itself in different
ways?

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 07:23 PM
Harald Armin Massa
 
Posts: n/a
Default Re: pgAdmin beta 3 query bug

On 10/14/06, Dave Page <dpage@vale-housing.co.uk> wrote:
>
> Hi Mike, George,
>
> I've been looking some more at this bug you are both experiencing. From
> what I recall, George is seeing it in the Query Tool, whilst Mike is
> seeing it in the Edit Grid. I've seen another report for each from
> Ezequias and Harald.
>
> Both tools share two important pieces of code:
>
> 1) ctlSqlGrid is our custom control that is based on wxGrid and is used
> to display the results. This code is primarily used to size rows/columns
> and extract data (ie. When exporting). Most of the real work is done by
> wxGrid which we've used since 1.0.
>
> 2) pgQueryThread. This is a class that is used to run a query
> asynchronously. It is this class that I fixed a couple of bugs in for
> beta 3 that had demonstrably caused crashes for me.
>
> I suspect that the problem that remains is an issue in the wxWidgets
> code as pgQueryThread is fairly simple and there is little else to go
> wrong in it that I can spot. I did find a seemingly unrelated threading
> bug in wx right before beta 3 which I was forced to workaround, however
> I found today that wxWidgets 2.7.1 has been released, in which that bug
> appears to have been fixed.
>
> So, before I go insane trying to track this down further, may I send you
> both an updated .exe built against wx2.7.1, in the hope that we've
> actually been seeing just one bug that's manifested itself in different
> ways?
>
> Regards, Dave.
>




--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-17-2008, 07:23 PM
mike
 
Posts: n/a
Default Re: pgAdmin beta 3 query bug

That would be ok by me. I would have no problem giving it a try.


On Sat, 2006-10-14 at 22:49 +0200, Harald Armin Massa wrote:
>
>
> On 10/14/06, Dave Page <dpage@vale-housing.co.uk> wrote:
> Hi Mike, George,
>
> I've been looking some more at this bug you are both
> experiencing. From
> what I recall, George is seeing it in the Query Tool, whilst
> Mike is
> seeing it in the Edit Grid. I've seen another report for each
> from
> Ezequias and Harald.
>
> Both tools share two important pieces of code:
>
> 1) ctlSqlGrid is our custom control that is based on wxGrid
> and is used
> to display the results. This code is primarily used to size
> rows/columns
> and extract data (ie. When exporting). Most of the real work
> is done by
> wxGrid which we've used since 1.0.
>
> 2) pgQueryThread. This is a class that is used to run a query
> asynchronously. It is this class that I fixed a couple of bugs
> in for
> beta 3 that had demonstrably caused crashes for me.
>
> I suspect that the problem that remains is an issue in the
> wxWidgets
> code as pgQueryThread is fairly simple and there is little
> else to go
> wrong in it that I can spot. I did find a seemingly unrelated
> threading
> bug in wx right before beta 3 which I was forced to
> workaround, however
> I found today that wxWidgets 2.7.1 has been released, in which
> that bug
> appears to have been fixed.
>
> So, before I go insane trying to track this down further, may
> I send you
> both an updated .exe built against wx2.7.1, in the hope that
> we've
> actually been seeing just one bug that's manifested itself in
> different
> ways?
>
> Regards, Dave.
>
>
>
> --
> GHUM Harald Massa
> persuadere et programmare
> Harald Armin Massa
> Reinsburgstraße 202b
> 70197 Stuttgart
> 0173/9409607
> -
> Python: the only language with more web frameworks than keywords.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:35 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com