Re: BUG #4568: sporadic error doing COUNT(*) on empty table

This mail landed in my Spam box... with this message:

"Warning: This message may not be from whom it claims to be. Beware of
following any links in it or of providing the sender with any personal
information"

You might want to report it again.

Best regards

On Mon, Dec 8, 2008 at 6:34 PM, Sameer Mahajan
<sameer_mahajan(at)symantec(dot)com>wrote:

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

--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device