doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY

Michael Paquier <michael@paquier.xyz>

Commit: f23d0145d0cfdb5c298ab97a6d497e97bbac6990
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-05-20T05:39:17Z
Releases: 13.22
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 <acozens@pixelpower.com>
Discussion: https://postgr.es/m/174733277404.1455388.11471370288789479593@wrigleys.postgresql.org
Backpatch-through: 13

Files

PathChange+/−
doc/src/sgml/ref/reindex.sgml modified +5 −2

Documentation touched

Discussion