REINDEX CONCURRENTLY unexpectedly fails

From: Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: REINDEX CONCURRENTLY unexpectedly fails
Date: 2019-11-13 14:29:53
Message-ID: CA+u7OA6gP7YAeCguyseusYcc=uR8+ypjCcgDDCTzjQ+k6S9ksQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2019-11-13 14:36:37 Re: REINDEX CONCURRENTLY unexpectedly fails
Previous Message Tomas Vondra 2019-11-13 13:41:14 Re: BUG #16111: Unexpected query compilation error “negative bitmapset member not allowed”