doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY

Michael Paquier <michael@paquier.xyz>

Commit: 54675d89863378b092c838a4e110551203d89b54
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-05-20T05:39:06Z
Releases: 18.0
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