Horton

REINDEX CONCURRENTLY unexpectedly fails

Manuel Rigger <rigger.manuel@gmail.com>

View thread View on postgr.es
From: Manuel Rigger <rigger.manuel@gmail.com>
To: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2019-11-13T14:29:53Z
Lists: pgsql-bugs 
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.

Best,
Manuel

Commits

  1. Fix concurrent indexing operations with temporary tables