Thread: Tables stat refresh error

Tables stat refresh error

From
"bdmytrak@eranet.pl"
Date:
Hi all,
I think there is a bug in refresh table stats functionality.
Scenario is:
1. Click on "Tables" node in DB objects tree
2. Click on "Stats" tab - You can see correct stats for all tables in schema
3. Click on particular table in DB objects tree (stats has been changed to present selected table stats)
4. Expand selected table node in DB objects 
5. Return to "Tables" node in the same schema (stats has been changed to present all tables stats)
6. Click Refresh button in button menu - here comes the bug: Stats are changed to present expanded table stats not all tables - as before refresh

Additionally, when You expand other tables nodes (do not select but only expand) stats window will present stats for last expanded table. For me it is confusing because selected node is "Tables" still.

pgAdmin 1.14.1 on Win XP sp3 - 32 bit

Regards,
Bartek

Re: Tables stat refresh error

From
Guillaume Lelarge
Date:
On Tue, 2011-12-20 at 10:26 +0100, bdmytrak@eranet.pl wrote:
> Hi all,
> I think there is a bug in refresh table stats functionality.
> Scenario is:
> 1. Click on "Tables" node in DB objects tree
> 2. Click on "Stats" tab - You can see correct stats for all tables in schema
> 3. Click on particular table in DB objects tree (stats has been changed to present selected table stats)
> 4. Expand selected table node in DB objects
> 5. Return to "Tables" node in the same schema (stats has been changed to present all tables stats)
> 6. Click Refresh button in button menu - here comes the bug: Stats are changed to present expanded table stats not
alltables - as before refresh
 
> Additionally , when You expand other tables nodes (do not select but only expand) stats window will present stats for
lastexpanded table. For me it is confusing because selected node is "Tables" still.
 
> pgAdmin 1.14.1 on Win XP sp3 - 32 bit

Sorry for answering so late. You're completely right, there is a huge
issue there. I know where the issue, not yet how to fix it. But we'll
work on it.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3:
http://www.postgresql-sessions.org



Re: Tables stat refresh error

From
Guillaume Lelarge
Date:
On Mon, 2012-01-02 at 22:37 +0100, Guillaume Lelarge wrote:
> On Tue, 2011-12-20 at 10:26 +0100, bdmytrak@eranet.pl wrote:
> > Hi all,
> > I think there is a bug in refresh table stats functionality.
> > Scenario is:
> > 1. Click on "Tables" node in DB objects tree
> > 2. Click on "Stats" tab - You can see correct stats for all tables in schema
> > 3. Click on particular table in DB objects tree (stats has been changed to present selected table stats)
> > 4. Expand selected table node in DB objects
> > 5. Return to "Tables" node in the same schema (stats has been changed to present all tables stats)
> > 6. Click Refresh button in button menu - here comes the bug: Stats are changed to present expanded table stats not
alltables - as before refresh
 
> > Additionally , when You expand other tables nodes (do not select but only expand) stats window will present stats
forlast expanded table. For me it is confusing because selected node is "Tables" still.
 
> > pgAdmin 1.14.1 on Win XP sp3 - 32 bit
> 
> Sorry for answering so late. You're completely right, there is a huge
> issue there. I know where the issue, not yet how to fix it. But we'll
> work on it.
> 

Fixed.

Thank you for your report.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org