diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-10-13 00:53:08 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-10-13 00:53:08 +0000 |
| commit | 8d54c2482b264ef621ec315f127a565ff4387042 (patch) | |
| tree | 2cdcf2750faf0774806f2af6ca4ef0e77bb4a91d /doc/src/sgml/ref/create_table.sgml | |
| parent | 5ec1341136941b538d07f54b2a6d7554857f8dc3 (diff) | |
| download | postgresql-8d54c2482b264ef621ec315f127a565ff4387042.tar.gz | |
Code review for LIKE INCLUDING patch --- clean up some cosmetic and not
so cosmetic stuff.
Diffstat (limited to 'doc/src/sgml/ref/create_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 42 |
1 files changed, 22 insertions, 20 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index a63333cb6f..5768c4cf2e 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.117 2009/10/12 19:49:24 adunstan Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.118 2009/10/13 00:53:07 tgl Exp $ PostgreSQL documentation --> @@ -231,7 +231,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR </para> <para> - Column storage parameters are also copied from parent tables. + Column <literal>STORAGE</> settings are also copied from parent tables. </para> <!-- @@ -285,25 +285,27 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR specified. </para> <para> - Storage parameters for the copied column definitions will only be copied - if <literal>INCLUDING STORAGE</literal> is specified. The default - behavior is to exclude storage parameters, resulting in the copied - columns in the new table having type-specific default parameters. For - more on storage parameters, see <xref linkend="storage-toast">. + <literal>STORAGE</> settings for the copied column definitions will only + be copied if <literal>INCLUDING STORAGE</literal> is specified. The + default behavior is to exclude <literal>STORAGE</> settings, resulting + in the copied columns in the new table having type-specific default + settings. For more on <literal>STORAGE</> settings, see + <xref linkend="storage-toast">. </para> <para> - Comments for the copied column, constraint, index and columns of index - definitions will only be copied if <literal>INCLUDING COMMENTS</literal> - is specified. The default behavior is to exclude comments, resulting in - the copied columns and constraints in the new table having no comments. + Comments for the copied columns, constraints, and indexes + will only be copied if <literal>INCLUDING COMMENTS</literal> + is specified. The default behavior is to exclude comments, resulting in + the copied columns and constraints in the new table having no comments. </para> <para> <literal>INCLUDING ALL</literal> is an abbreviated form of <literal>INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS</literal>. </para> <para> - Note also that unlike <literal>INHERITS</literal>, copied columns and - constraints are not merged with similarly named columns and constraints. + Note also that unlike <literal>INHERITS</literal>, columns and + constraints copied by <literal>LIKE</> are not merged with similarly + named columns and constraints. If the same name is specified explicitly or in another <literal>LIKE</literal> clause, an error is signalled. </para> @@ -752,14 +754,14 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR <para> Enables or disables the autovacuum daemon on a particular table. If true, the autovacuum daemon will initiate a <command>VACUUM</> operation - on a particular table when the number of updated or deleted tuples exceeds - <literal>autovacuum_vacuum_threshold</> plus - <literal>autovacuum_vacuum_scale_factor</> times the number of live tuples + on a particular table when the number of updated or deleted tuples exceeds + <literal>autovacuum_vacuum_threshold</> plus + <literal>autovacuum_vacuum_scale_factor</> times the number of live tuples currently estimated to be in the relation. Similarly, it will initiate an <command>ANALYZE</> operation when the number of inserted, updated or deleted tuples exceeds - <literal>autovacuum_analyze_threshold</> plus - <literal>autovacuum_analyze_scale_factor</> times the number of live tuples + <literal>autovacuum_analyze_threshold</> plus + <literal>autovacuum_analyze_scale_factor</> times the number of live tuples currently estimated to be in the relation. If false, this table will not be autovacuumed, except to prevent transaction Id wraparound. See <xref linkend="vacuum-for-wraparound"> for @@ -775,7 +777,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR <listitem> <para> Minimum number of updated or deleted tuples before initiate a - <command>VACUUM</> operation on a particular table. + <command>VACUUM</> operation on a particular table. </para> </listitem> </varlistentry> @@ -834,7 +836,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR <para> Custom <xref linkend="guc-vacuum-freeze-min-age"> parameter. Note that autovacuum will ignore attempts to set a per-table - <literal>autovacuum_freeze_min_age</> larger than the half system-wide + <literal>autovacuum_freeze_min_age</> larger than the half system-wide <xref linkend="guc-autovacuum-freeze-max-age"> setting. </para> </listitem> |
