Обсуждение: Tables stat refresh error
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
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
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