Hello Im just getting started using postgres and Ive run run into a
problem with count(*):
When I do "select count(*) from mytable" or "select count(*) from
mytable where mycolumn=x" then I get wrong number. The number of rows
returned is lower than the actual number. How can that happen? The
table is generally updated from JDBC with autocommit true and there is
no concurrent acess to the database yet - so I shouldnt have any open
transactions. The first few rows in the table was added from
pgAdminIII which has had its database connection time out on occasions
long after I was finished doing any work though..
Im using postgres 8.4.0 on linux 32 bit. Hope someone can help?