The following bug has been logged online:
Bug reference: 4568
Logged by: Sameer Mahajan
Email address: sameer_mahajan(at)symantec(dot)com
PostgreSQL version: 8.1.4-1.3
Operating system: Suse Linux
Description: sporadic error doing COUNT(*) on empty table
Details:
While performing COUNT(*) on an empty table via libpq APIs I am spradically
getting an error.
the error is returning 7 for PQresultStatus(res)
and 0 for PQntuples(res) where res is the PGresult returned by this count(*)
query on the empty table.