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)