Skip site navigation (1) Skip section navigation (2)

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

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Sameer Mahajan" <sameer_mahajan(at)symantec(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4568: sporadic error doing COUNT(*) on empty table
Date: 2008-12-14 14:59:43
Message-ID: 65937bea0812140659l6a2a0087jb93b5c4018c4e0d5@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(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

In response to

Responses

pgsql-bugs by date

Next:From: John R PierceDate: 2008-12-14 18:00:30
Subject: Re: BUG #4568: sporadic error doing COUNT(*) on empty table
Previous:From: Tom LaneDate: 2008-12-12 15:37:35
Subject: Re: ECPG Preprocessor throws Syntax Error [Devel Repository]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group