Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data - Mailing list pgsql-bugs

From Victor Yegorov
Subject Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Date
Msg-id CAGnEbogw58YwSApBuAgSLDK4yNJ6Hu3=1A4GpqZtwbyuyGrYNw@mail.gmail.com
Whole thread Raw
In response to CREATE INDEX CONCURRENTLY does not index prepared xact's data  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
List pgsql-bugs
сб, 19 дек. 2020 г. в 18:13, Andrey Borodin <x4mmm@yandex-team.ru>:
Steps to reproduce:
create extension if not exists amcheck;
create table if not exists t1(i int);
begin;
insert into t1 values(1);
prepare transaction 'x';
create index concurrently i1 on t1(i);
commit prepared 'x';
select bt_index_check('i1', true);

I observe:
NOTICE:  heap tuple (1,8) from table "t1" lacks matching index tuple within index "i1"
I expect: awaiting 'x' commit before index is created, correct index after.

CREATE INDEX CONCURRENTLY isn't supposed to be run inside a transaction?.. 


--
Victor Yegorov

pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Next
From: Andrey Borodin
Date:
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data