Postgres Pro
Downloads
Home   >   mailing lists

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

From Sameer Mahajan
Subject BUG #4568: sporadic error doing COUNT(*) on empty table
Date
Msg-id 200812081304.mB8D4OAY074066@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4568: sporadic error doing COUNT(*) on empty table  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently
Next
From: Marc Schablewski
Date:
Subject: Re: BUG #4565: nextval not updated during wal replication, leading to pk violations