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

Appearance settings

Commit 1464755

Browse filesBrowse files
committed
Doc: remove obsolete statements about system OID columns in ALTER TABLE.
Missed in commit 578b229.
1 parent b90e6ce commit 1464755
Copy full SHA for 1464755

File tree

1 file changed

+6
-10
lines changed
Filter options

1 file changed

+6
-10
lines changed

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

Copy file name to clipboardExpand all lines: doc/src/sgml/ref/alter_table.sgml
+6-10Lines changed: 6 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -616,9 +616,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
616616
<term><literal>SET WITHOUT OIDS</literal></term>
617617
<listitem>
618618
<para>
619-
Backward compatibility syntax for removing the <literal>oid</literal>
620-
system column. As oid system columns cannot be added anymore, this never
621-
has an effect.
619+
Backward-compatible syntax for removing the <literal>oid</literal>
620+
system column. As <literal>oid</literal> system columns cannot be
621+
added anymore, this never has an effect.
622622
</para>
623623
</listitem>
624624
</varlistentry>
@@ -744,8 +744,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
744744
<para>
745745
This form links the table to a composite type as though <command>CREATE
746746
TABLE OF</command> had formed it. The table's list of column names and types
747-
must precisely match that of the composite type; the presence of
748-
an <literal>oid</literal> system column is permitted to differ. The table must
747+
must precisely match that of the composite type. The table must
749748
not inherit from any other table. These restrictions ensure
750749
that <command>CREATE TABLE OF</command> would permit an equivalent table
751750
definition.
@@ -1178,8 +1177,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
11781177
the column contents and the old type is either binary coercible to the new
11791178
type or an unconstrained domain over the new type, a table rewrite is not
11801179
needed; but any indexes on the affected columns must still be rebuilt.
1181-
Adding or removing a system <literal>oid</literal> column also requires
1182-
rewriting the entire table. Table and/or index rebuilds may take a
1180+
Table and/or index rebuilds may take a
11831181
significant amount of time for a large table; and will temporarily require
11841182
as much as double the disk space.
11851183
</para>
@@ -1208,9 +1206,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
12081206
column. Thus, dropping a column is quick but it will not immediately
12091207
reduce the on-disk size of your table, as the space occupied
12101208
by the dropped column is not reclaimed. The space will be
1211-
reclaimed over time as existing rows are updated. (These statements do
1212-
not apply when dropping the system <literal>oid</literal> column; that is done
1213-
with an immediate rewrite.)
1209+
reclaimed over time as existing rows are updated.
12141210
</para>
12151211

12161212
<para>

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.