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

Commit879808e

Browse files
committed
Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free.
The system realizes that DEFAULT NULL is dummy in simple cases, but not ifa cast function (such as a length coercion) needs to be applied. It'sdubious that suppressing that function call would be appropriate, anyway.For the moment, let's just adjust the docs to say that you should omit theDEFAULT clause if you don't want a rewrite to happen. Per gripe from AmitLangote.
1 parent04e298b commit879808e

File tree

1 file changed

+8
-4
lines changed

1 file changed

+8
-4
lines changed

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

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -854,14 +854,18 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable>
854854
When a column is added with <literal>ADD COLUMN</literal>, all existing
855855
rows in the table are initialized with the column's default value
856856
(NULL if no <literal>DEFAULT</> clause is specified).
857+
If there is no <literal>DEFAULT</> clause, this is merely a metadata
858+
change and does not require any immediate update of the table's data;
859+
the added NULL values are supplied on readout, instead.
857860
</para>
858861

859862
<para>
860-
Adding a column with a non-null default or changing the type of an
861-
existing column will require the entire table and indexes to be rewritten.
862-
As an exception, if the <literal>USING</> clause does not change the column
863+
Adding a column with a <literal>DEFAULT</> clause or changing the type of
864+
an existing column will require the entire table and its indexes to be
865+
rewritten. As an exception when changing the type of an existing column,
866+
if the <literal>USING</> clause does not change the column
863867
contents and the old type is either binary coercible to the new type or
864-
an unconstrained domain over the new type, a table rewrite is not needed,
868+
an unconstrained domain over the new type, a table rewrite is not needed;
865869
but any indexes on the affected columns must still be rebuilt. Adding or
866870
removing a system <literal>oid</> column also requires rewriting the entire
867871
table. Table and/or index rebuilds may take a significant amount of time

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp