doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY

Michael Paquier <michael@paquier.xyz>

Commit: a79ede0a4ebff1434d6ffd2a15339a1c574bbf6e
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-05-20T05:39:15Z
Releases: 14.19
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