Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Marc Cousin
On Monday 10 April 2006 15:37, Andreas Pflug wrote: > Always stay on the list, private mail frequently gets dropped!!! Yeah, my mistake :) > > > The table contains 0 rows, but there are several tables that inherit from > > this one. And those table contain the real rows. > > Ok, you didn't mention

Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Marc Cousin
On Monday 10 April 2006 15:18, you wrote: > Marc Cousin wrote: > > all the databases of the cluster are regularly vacuumed (at least once a > > day), all the stats are up to date. > > If stats say 0 ("estimated rows") rows but 40M rows are present stats >

Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Marc Cousin
e content of all the partitions). On Monday 10 April 2006 09:54, Andreas Pflug wrote: > Marc Cousin wrote: > > Hi, > > > > I've got a partitionned table with PG 8.1, and I'm using pgadmin3 1.4.1. > > I'm having problems using pgadmin because it tries to count

[pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Marc Cousin
Hi, I've got a partitionned table with PG 8.1, and I'm using pgadmin3 1.4.1. I'm having problems using pgadmin because it tries to count the elements of the partitionned table... The main table contains 0 record (so the stats say 0), so pgadmin decides it can count all the elements from the tab