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 по дате отправления: