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

Commitf5dc03d

Browse files
committed
Mention that when alter rewrites a table, indexes are also rebuilt.
1 parentd8cd283 commitf5dc03d

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

‎doc/src/sgml/ref/alter_table.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.114 2010/06/09 17:48:10 alvherre Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.115 2010/06/24 14:57:21 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -689,8 +689,8 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
689689

690690
<para>
691691
Adding a column with a non-null default or changing the type of an
692-
existing column will require the entire table to be rewritten. This
693-
might take a significant amount of time for a large table; and it will
692+
existing column will require the entire tableand indexesto be rewritten.
693+
Thismight take a significant amount of time for a large table; and it will
694694
temporarily require double the disk space. Adding or removing a system
695695
<literal>oid</> column likewise requires rewriting the entire table.
696696
</para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp