BUG #15023: problem with pg_statistic - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      15023
Logged by:          kurt rudahl
Email address:      ktr@goldin-rudahl.com
PostgreSQL version: Unsupported/Unknown
Operating system:   linux
Description:

Problem: cannot reindex pg_statistic
         therefore cannot vacuum

Steps to recreate:
1. restart postgresql
2. psql thaistocks

\set VERBOSITY verbose
thaistocks=# reindex table pg_statistic;
ERROR:  23505: could not create unique index
DETAIL:  Table contains duplicated values.
LOCATION:  comparetup_index, tuplesort.c:2163

thaistocks=# select starelid,staattnum from pg_statistic group by
starelid,staattnum having count(*) > 1;
 starelid | staattnum 
----------+-----------
    10723 |         5
    10728 |         1
     1260 |         9
(3 rows)