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 | | [EMAIL PROTECTED] | | 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings