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

Commit88bd306

Browse files
committed
> Neil Conway <nconway@klamath.dyndns.org> writes:
> > This patch improves the documentation of the UPDATE and ALTER TABLE> > commands to elaborate on the effect of specifying an "ONLY" clause.>> Unfortunately this is still only half the truth ... see the> SQL_INHERITANCE configuration variable.Okay, I've attached an updated patch with more information onSQL_INHERITANCE and inheritance behavior in prior releases.Neil Conway
1 parent66eb8df commit88bd306

File tree

3 files changed

+24
-6
lines changed

3 files changed

+24
-6
lines changed

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

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.48 2002/08/02 18:15:04 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.49 2002/08/15 02:59:18 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -60,7 +60,15 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable>
6060
<term><replaceable class="PARAMETER"> table </replaceable></term>
6161
<listitem>
6262
<para>
63-
The name (possibly schema-qualified) of an existing table to alter.
63+
The name (possibly schema-qualified) of an existing table to
64+
alter. If <literal>ONLY</> is specified, only that table is
65+
altered. If <literal>ONLY</> is not specified, the table and all
66+
its descendant tables (if any) are updated. <literal>*</> can be
67+
appended to the table name to indicate that descendant tables are
68+
to be scanned, but in the current version, this is the default
69+
behavior. (In releases before 7.1, <literal>ONLY</> was the
70+
default behavior.) The default can be altered by changing the
71+
<option>SQL_INHERITANCE</option> configuration option.
6472
</para>
6573
</listitem>
6674
</varlistentry>

‎doc/src/sgml/ref/select.sgml‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.55 2002/08/04 19:48:09 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.56 2002/08/15 02:59:18 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -131,7 +131,9 @@ where <replaceable class="PARAMETER">from_item</replaceable> can be:
131131
tables (if any) are scanned. <literal>*</> can be appended to the
132132
table name to indicate that descendant tables are to be scanned, but
133133
in the current version, this is the default behavior. (In releases
134-
before 7.1, <literal>ONLY</> was the default behavior.)
134+
before 7.1, <literal>ONLY</> was the default behavior.) The
135+
default behavior can be modified by changing the
136+
<option>SQL_INHERITANCE</option> configuration option.
135137
</para>
136138
</listitem>
137139
</varlistentry>

‎doc/src/sgml/ref/update.sgml‎

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.19 2002/04/23 02:07:16 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.20 2002/08/15 02:59:18 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -40,7 +40,15 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> SET <replacea
4040
<term><replaceable class="PARAMETER">table</replaceable></term>
4141
<listitem>
4242
<para>
43-
The name (optionally schema-qualified) of an existing table.
43+
The name (optionally schema-qualified) of an existing table. If
44+
<literal>ONLY</> is specified, only that table is updated. If
45+
<literal>ONLY</> is not specified, the table and all its
46+
descendant tables (if any) are updated. <literal>*</> can be
47+
appended to the table name to indicate that descendant tables are
48+
to be scanned, but in the current version, this is the default
49+
behavior. (In releases before 7.1, <literal>ONLY</> was the
50+
default behavior.) The default can be altered by changing the
51+
<option>SQL_INHERITANCE</option> configuration option.
4452
</para>
4553
</listitem>
4654
</varlistentry>

0 commit comments

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