Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX CONCURRENTLY unexpectedly fails - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: REINDEX CONCURRENTLY unexpectedly fails
Date
Msg-id CAMkU=1zfiK9wV7KqtFBMMoyPnM9T_F=SvnUJPao1hC7AUZy6KQ@mail.gmail.com
Whole thread Raw
In response to REINDEX CONCURRENTLY unexpectedly fails  (Manuel Rigger <rigger.manuel@gmail.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Manuel Rigger
Date:
Subject: REINDEX CONCURRENTLY unexpectedly fails
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #16112: large, unexpected memory consumption