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  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #15001: planner cann't distinguish composite index?
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15024: I am a beginer and in learning face