Good day,
cenes=> select version(); version
---------------------------------------------------------------PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc
2.95.2
(1 row)
cenes=> \d partner_views Table "partner_views"Attribute | Type | Modifier
------------+-----------+----------partner_id | integer | not nulltimestamp | timestamp | not null
Indices: partner_id_partner_views_key, timestamp_partner_views_key
cenes=> select count(partner_id), partner_id from partner_views group by
partner_id order by partner_id;count | partner_id
--------+------------ 21473 | 0 1 | 1672116636 | 0 266 | 1670 17991 | 1672
1 | 0 79614 | 1672 3723 | 1677 39 | 1692 30150 | 1814 3853 | 1874 4951 |
1905 2 | 1948 28 | 2101 241 | 2129
(15 rows)
how can this be? is it a known bug which is fixed in 7.1.3?