сб, 19 дек. 2020 г. в 18:13, Andrey Borodin <x4mmm(at)yandex-team(dot)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