pgsql: amcheck: Fix snapshot usage in bt_index_parent_check

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема pgsql: amcheck: Fix snapshot usage in bt_index_parent_check
Дата
Msg-id E1vRCsy-002nI3-2w@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
amcheck: Fix snapshot usage in bt_index_parent_check

We were using SnapshotAny to do some index checks, but that's wrong and
causes spurious errors when used on indexes created by CREATE INDEX
CONCURRENTLY.  Fix it to use an MVCC snapshot, and add a test for it.

This problem came in with commit 5ae2087202af, which introduced
uniqueness check.  Backpatch to 17.

Author: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Reviewed-by: Andrey Borodin <x4mmm@yandex-team.ru>
Backpatch-through: 17
Discussion: https://postgr.es/m/CANtu0ojmVd27fEhfpST7RG2KZvwkX=dMyKUqg0KM87FkOSdz8Q@mail.gmail.com

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/df93f94dda51cae1d81526472e41bbde0a089377

Modified Files
--------------
contrib/amcheck/t/002_cic.pl    | 23 +++++++++++
contrib/amcheck/verify_nbtree.c | 86 +++++++++++++++++------------------------
doc/src/sgml/amcheck.sgml       |  2 +-
3 files changed, 60 insertions(+), 51 deletions(-)


В списке pgsql-committers по дате отправления: