BUG #15023: problem with pg_statistic

Поиск
Список
Период
Сортировка
Искать
От
PG Bug reporting form
Тема
BUG #15023: problem with pg_statistic
Дата
Msg-id
20180121025924.3633.29967@wrigleys.postgresql.org
Список
Дерево обсуждения
BUG #15023: problem with pg_statistic PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15023: problem with pg_statistic Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: BUG #15023: problem with pg_statistic Michael Paquier <michael.paquier@gmail.com> 
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 по дате отправления
Предыдущее
От: Tomas Vondra
Дата:
Следующее
От: PG Bug reporting form
Дата:
FAQ