Re: REINDEX CONCURRENTLY unexpectedly fails

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: REINDEX CONCURRENTLY unexpectedly fails
Дата
Msg-id CAMkU=1zfiK9wV7KqtFBMMoyPnM9T_F=SvnUJPao1hC7AUZy6KQ@mail.gmail.com
обсуждение исходный текст
Ответ на REINDEX CONCURRENTLY unexpectedly fails  (Manuel Rigger <rigger.manuel@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Nov 13, 2019 at 9:30 AM Manuel Rigger <rigger.manuel@gmail.com> wrote:
Hi everyone,

On the latest trunk version, I get an error "index "t0_pkey_ccnew"
already contains data" when using REINDEX CONCURRENTLY:

CREATE TEMP TABLE t0(c1 INT PRIMARY KEY) ON COMMIT DELETE ROWS;
REINDEX TABLE CONCURRENTLY t0; -- unexpected: ERROR:  index
"t0_pkey_ccnew" already contains data

Is this expected? I think I did not observe this error on earlier
PostgreSQL versions.

For what it is worth, I get the samer error in 12.0.  And the command doesn't exist in 11.
 
The "ON COMMIT DELETE ROWS" is necessary to repodcue the problem, but the index doesn't need to be primary key.

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Manuel Rigger
Дата:
Сообщение: REINDEX CONCURRENTLY unexpectedly fails
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #16112: large, unexpected memory consumption