git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0bf6246) | patch
Improve some error messages with invalid indexes for REINDEX CONCURRENTLY
Thu, 7 Dec 2023 05:27:54 +0000 (14:27 +0900)
Thu, 7 Dec 2023 05:27:54 +0000 (14:27 +0900)
commit d43bd090a8fee81fe88eb1e9e15e30d30ee130ed
Improve some error messages with invalid indexes for REINDEX CONCURRENTLY

An invalid index is skipped when doing REINDEX CONCURRENTLY at table
level, with INDEX_CORRUPTED used as errcode. This is confusing,
because an invalid index could exist after an interruption. The errcode
is switched to OBJECT_NOT_IN_PREREQUISITE_STATE instead, as per a
suggestion from Andres Freund.

While on it, the error messages are reworded, and a hint is added,
telling how to rebuild an invalid index in this case. This has been
suggested by Noah Misch.

Discussion: https://postgr.es/m/20231118230958.4fm3fhk4ypshxopa@awork3.anarazel.de
src/backend/commands/indexcmds.c diff | blob | blame | history
src/test/regress/expected/create_index.out diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /