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

Commita79ede0

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 parent0420b24 commita79ede0

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
@@ -446,14 +446,17 @@ Indexes:
446446
</programlisting>
447447

448448
If the index marked <literal>INVALID</literal> is suffixed
449-
<literal>ccnew</literal>, then it corresponds to the transient
449+
<literal>_ccnew</literal>, then it corresponds to the transient
450450
index created during the concurrent operation, and the recommended
451451
recovery method is to drop it using <literal>DROP INDEX</literal>,
452452
then attempt <command>REINDEX CONCURRENTLY</command> again.
453-
If the invalid index is instead suffixed <literal>ccold</literal>,
453+
If the invalid index is instead suffixed <literal>_ccold</literal>,
454454
it corresponds to the original index which could not be dropped;
455455
the recommended recovery method is to just drop said index, since the
456456
rebuild proper has been successful.
457+
A nonzero number may be appended to the suffix of the invalid index
458+
names to keep them unique, like <literal>_ccnew1</literal>,
459+
<literal>_ccold2</literal>, etc.
457460
</para>
458461

459462
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp