]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Add test for CREATE INDEX CONCURRENTLY with not-so-immutable predicate
authorMichael Paquier <michael@paquier.xyz>
Mon, 28 Jun 2021 02:17:20 +0000 (11:17 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 28 Jun 2021 02:17:20 +0000 (11:17 +0900)
commit38ca11adeb5a9a2812510048dd0d43dfbd05caf8
tree1c22fc8b115fe874f0bd3d8a678891a506b77dc6
parent08acba558bba3e67ce798fcc26816878a8a6b114
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
src/test/regress/expected/create_index.out
src/test/regress/sql/create_index.sql