Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit009e8a8

Browse files
committed
doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY
Invalid indexes are suffixed with "_ccnew" or "_ccold". Thedocumentation missed to mention the initial underscore.ChooseRelationName() may also append an extra number if indexes with asimilar 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.orgBackpatch-through: 13
1 parent72fe74c commit009e8a8

File tree

1 file changed

+5
-2
lines changed

1 file changed

+5
-2
lines changed

‎doc/src/sgml/ref/reindex.sgml

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -451,14 +451,17 @@ Indexes:
451451
</programlisting>
452452

453453
If the index marked <literal>INVALID</literal> is suffixed
454-
<literal>ccnew</literal>, then it corresponds to the transient
454+
<literal>_ccnew</literal>, then it corresponds to the transient
455455
index created during the concurrent operation, and the recommended
456456
recovery method is to drop it using <literal>DROP INDEX</literal>,
457457
then attempt <command>REINDEX CONCURRENTLY</command> again.
458-
If the invalid index is instead suffixed <literal>ccold</literal>,
458+
If the invalid index is instead suffixed <literal>_ccold</literal>,
459459
it corresponds to the original index which could not be dropped;
460460
the recommended recovery method is to just drop said index, since the
461461
rebuild proper has been successful.
462+
A nonzero number may be appended to the suffix of the invalid index
463+
names to keep them unique, like <literal>_ccnew1</literal>,
464+
<literal>_ccold2</literal>, etc.
462465
</para>
463466

464467
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp