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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
