Re: BUG #4568: sporadic error doing COUNT(*) on empty table - Mailing list pgsql-bugs

From Gurjeet Singh
Subject Re: BUG #4568: sporadic error doing COUNT(*) on empty table
Date
Msg-id 65937bea0812140659l6a2a0087jb93b5c4018c4e0d5@mail.gmail.com
Whole thread Raw
In response to BUG #4568: sporadic error doing COUNT(*) on empty table  ("Sameer Mahajan" <sameer_mahajan@symantec.com>)
Responses Re: BUG #4568: sporadic error doing COUNT(*) on empty table  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
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@symantec.com>wrote:

>
> The following bug has been logged online:
>
> Bug reference:      4568
> Logged by:          Sameer Mahajan
> Email address:      sameer_mahajan@symantec.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ECPG Preprocessor throws Syntax Error [Devel Repository]
Next
From: John R Pierce
Date:
Subject: Re: BUG #4568: sporadic error doing COUNT(*) on empty table