doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY
authorMichael Paquier <[email protected]>
Tue, 20 May 2025 05:39:17 +0000 (14:39 +0900)
committerMichael Paquier <[email protected]>
Tue, 20 May 2025 05:39:17 +0000 (14:39 +0900)
commitf23d0145d0cfdb5c298ab97a6d497e97bbac6990
tree1c06f379333ceb5ffc39180dfbe100cdc2a0622a
parent7ee00918f7cdd76c8c1120f019288dd71d48f42d
doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY

Invalid indexes are suffixed with "_ccnew" or "_ccold".  The
documentation missed to mention the initial underscore.
ChooseRelationName() may also append an extra number if indexes with a
similar name already exist; let's add a note about that too.

Author: Alec Cozens <[email protected]>
Discussion: https://postgr.es/m/174733277404.1455388.11471370288789479593@wrigleys.postgresql.org
Backpatch-through: 13
doc/src/sgml/ref/reindex.sgml