Horton

Add test for CREATE INDEX CONCURRENTLY with not-so-immutable predicate

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: ce8949c4b6e225a3ae31e4b7ccdef0f7ab70ada6
Author: Michael Paquier <michael@paquier.xyz>
Date: 2021-06-28T02:17:16Z
Releases: 12.8 
Add test for CREATE INDEX CONCURRENTLY with not-so-immutable predicate

83158f7 has improved index_set_state_flags() so as it is possible to use
transactional updates when updating pg_index state flags, but there was
not really a test case which stressed directly the possibility it fixed.
This commit adds such a test, using a predicate that looks valid in
appearance but calls a stable function.

Author: Andrey Lepikhov
Discussion: https://postgr.es/m/9b905019-5297-7372-0ad2-e1a4bb66a719@postgrespro.ru
Backpatch-through: 9.6

Files

PathChange+/−
src/test/regress/expected/create_index.out modified +12 −0
src/test/regress/sql/create_index.sql modified +12 −1

Discussion