I recovered my database by pg_resetxlog and then did a dump , initdb ,
reload.
one of the tables exhibited this phenomenon. I thought it was worth
mentioning
to the developers.
Regds
mallah.
rt2=# SELECT name from users group by name having count(*) > 1 limit 20;
+----------------------+
| name |
+----------------------+
| �˾ |
| ����163.com |
| �(at)hotmail(dot)com |
| p� |
+----------------------+
(4 rows)
Time: 1961.199 ms
rt2=#
rt2=# SELECT name from users group by name having count(*) > 1 ;
+------+
| name |
+------+
+------+
(0 rows)
Time: 789.184 ms