Horton

Teach contrib/amcheck to check the unique constraint violation

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 5ae2087202af9fd804c8b8d76954bdd8bdf31e51
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2023-10-27T21:21:23Z
Releases: 17.0 
Teach contrib/amcheck to check the unique constraint violation

Add the 'checkunique' argument to bt_index_check() and bt_index_parent_check().
When the flag is specified the procedures will check the unique constraint
violation for unique indexes.  Only one heap entry for all equal keys in
the index should be visible (including posting list entries).  Report an error
otherwise.

pg_amcheck called with the --checkunique option will do the same check for all
the indexes it checks.

Author: Anastasia Lubennikova <lubennikovaav@gmail.com>
Author: Pavel Borisov <pashkin.elfe@gmail.com>
Author: Maxim Orlov <orlovmg@gmail.com>
Reviewed-by: Mark Dilger <mark.dilger@enterprisedb.com>
Reviewed-by: Zhihong Yu <zyu@yugabyte.com>
Reviewed-by: Peter Geoghegan <pg@bowt.ie>
Reviewed-by: Aleksander Alekseev <aleksander@timescale.com>
Discussion: https://postgr.es/m/CALT9ZEHRn5xAM5boga0qnrCmPV52bScEK2QnQ1HmUZDD301JEg%40mail.gmail.com

Files

PathChange+/−
contrib/amcheck/amcheck--1.3--1.4.sql added +29 −0
contrib/amcheck/amcheck.control modified +1 −1
contrib/amcheck/expected/check_btree.out modified +42 −0
contrib/amcheck/Makefile modified +1 −1
contrib/amcheck/meson.build modified +2 −0
contrib/amcheck/sql/check_btree.sql modified +14 −0
contrib/amcheck/t/004_verify_nbtree_unique.pl added +244 −0
contrib/amcheck/verify_nbtree.c modified +315 −15
doc/src/sgml/amcheck.sgml modified +10 −4
doc/src/sgml/ref/pg_amcheck.sgml modified +11 −0
src/bin/pg_amcheck/pg_amcheck.c modified +46 −2
src/bin/pg_amcheck/t/003_check.pl modified +50 −0
src/bin/pg_amcheck/t/005_opclass_damage.pl modified +65 −0

Documentation touched

Discussion