doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY
authorMichael Paquier <michael@paquier.xyz>
Tue, 20 May 2025 05:39:14 +0000 (14:39 +0900)
committerMichael Paquier <michael@paquier.xyz>
Tue, 20 May 2025 05:39:14 +0000 (14:39 +0900)
commit009e8a85d32aaea7aa19505fc9023dcb9a80e255
treef257999853cceef2804281872e2ffd2f0d97cfaf
parent72fe74ca533375fa04264f976d4c4971c6804dce
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: http://postgr.es/m/174733277404.1455388.11471370288789479593@wrigleys.postgresql.org
Backpatch-through: 13
doc/src/sgml/ref/reindex.sgml