BUG #15023: problem with pg_statistic
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #15023: problem with pg_statistic |
| Дата | |
| Msg-id | 20180121025924.3633.29967@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #15023: problem with pg_statistic
|
| Список | 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)
В списке pgsql-bugs по дате отправления: