Skip to content

Commit 07ee401

Browse files
author
Liudmila Mantrova
committed
Doc fix for pathman declarative syntax - form vs clause terms
1 parent c655eec commit 07ee401

File tree

2 files changed

+16
-16
lines changed

2 files changed

+16
-16
lines changed

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

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -745,7 +745,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
745745
<term><literal>VALUES LESS THAN (<replaceable class="PARAMETER">value</replaceable>)</literal></term>
746746
<listitem>
747747
<para>
748-
This form specifies the range of values to include into a single partition. The specified <literal>value</literal> is not included into the created partition.
748+
This clause specifies the range of values to include into a single partition. The specified <replaceable>value</replaceable> is not included into the created partition.
749749
</para>
750750
</listitem>
751751
</varlistentry>
@@ -754,7 +754,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
754754
<term><literal>TABLESPACE <replaceable class="PARAMETER">tablespace_name</replaceable></literal></term>
755755
<listitem>
756756
<para>
757-
This form specifies the name of the tablespace to which the created partition will belong.
757+
This clause specifies the name of the tablespace to which the created partition will belong.
758758
If not specified, <xref linkend="guc-default-tablespace"> is consulted.
759759
</para>
760760
</listitem>
@@ -769,21 +769,21 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
769769

770770
<varlistentry>
771771
<term><literal>SPLIT PARTITION <replaceable class="PARAMETER">partition_name</replaceable></literal></term>
772-
<listitem><para>This form separates a range partition into two based on the value provided in the <literal>AT</literal> form.
772+
<listitem><para>This form separates a range partition into two based on the value provided in the <literal>AT</literal> clause.
773773
</para>
774774
</listitem>
775775
</varlistentry>
776776

777777
<varlistentry>
778778
<term><literal>AT (<replaceable class="PARAMETER">value</replaceable>)</literal></term>
779-
<listitem><para>This form specifies the value by which to split a range partition. The provided value serves as the lower bound of the second partition.
779+
<listitem><para>This clause specifies the value by which to split a range partition. The provided value serves as the lower bound of the right partition.
780780
</para>
781781
</listitem>
782782
</varlistentry>
783783

784784
<varlistentry>
785785
<term><literal>INTO</literal></term>
786-
<listitem><para>This form specifies one or more target partitions. Use this form when performing <literal>SPLIT</literal> and <literal>MERGE</literal> actions. If you omit this form when splitting partitions, the left partition will use the parent partion name, and the right partition name will be generated automatically.
786+
<listitem><para>This clause specifies one or more target partitions. Use this clause when performing <literal>SPLIT</literal> and <literal>MERGE</literal> actions. If you omit this clause when splitting partitions, the left partition will use the parent partion name, and the right partition name will be generated automatically.
787787
</para>
788788
</listitem>
789789
</varlistentry>
@@ -797,21 +797,21 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
797797

798798
<varlistentry>
799799
<term><literal>RENAME PARTITION <replaceable class="PARAMETER">partition_name</replaceable></literal></term>
800-
<listitem><para>This form renames a partition. The new partition name must be specified in the <literal>TO</literal> form.
800+
<listitem><para>This form renames a partition. The new partition name must be specified in the <literal>TO</literal> clause.
801801
</para>
802802
</listitem>
803803
</varlistentry>
804804

805805
<varlistentry>
806806
<term><literal>TO <replaceable class="PARAMETER">new_partition_name</replaceable></literal></term>
807-
<listitem><para>This form specifies a new partition name.
807+
<listitem><para>This clause specifies a new partition name.
808808
</para>
809809
</listitem>
810810
</varlistentry>
811811

812812
<varlistentry>
813813
<term><literal>MOVE PARTITION <replaceable class="PARAMETER">partition_name</replaceable></literal></term>
814-
<listitem><para>This form moves the partition to a different tablespace specified in the <literal>TABLESPACE</literal> form.
814+
<listitem><para>This form moves the partition to a different tablespace specified in the <literal>TABLESPACE</literal> clause.
815815
</para>
816816
</listitem>
817817
</varlistentry>
@@ -834,7 +834,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
834834
<term><literal>PARTITION BY</literal></term>
835835
<listitem>
836836
<para>
837-
This clause splits the created table into partitions based on the specified partitioning options.
837+
This form splits the created table into partitions based on the specified partitioning options.
838838
The supported partitioning options are:</para>
839839

840840
<variablelist>
@@ -864,7 +864,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
864864
<term><literal>PARTITIONS <replaceable class="PARAMETER">partition_count</replaceable></literal></term>
865865
<listitem>
866866
<para>
867-
Specify the number of partitions to create with hash partitioning. Alternatively, you can specify the exact partitions to create using <literal>PARTITION</literal> option.
867+
Specify the number of partitions to create with hash partitioning.
868868
</para>
869869
</listitem>
870870
</varlistentry>
@@ -873,7 +873,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
873873
<term><literal>START FROM (<replaceable class="PARAMETER">start_value</replaceable>)</literal></term>
874874
<listitem>
875875
<para>
876-
Specify the lower bound of the first partition to create. The <literal>start_value</literal> must be not greater than the smallest value in the partitioning key column. Otherwise, <filename>pg_pathman</filename> returns the corresponding error.
876+
Specify the lower bound of the first partition to create. The <replaceable>start_value</replaceable> must be not greater than the smallest value in the partitioning key column. Otherwise, <filename>pg_pathman</filename> returns the corresponding error.
877877
</para>
878878
</listitem>
879879
</varlistentry>
@@ -882,7 +882,7 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
882882
<term><literal>INTERVAL <replaceable class="PARAMETER">interval</replaceable></literal></term>
883883
<listitem>
884884
<para>
885-
Specify the interval for range partitioning. When you insert data outside of the existing data range, all new partitions will be created with this interval. You can omit this option if you specify the exact partitions to create using the <literal>PARTITION</literal> option. If the <literal>INTERVAL</literal> is not specified, <filename>pg_pathman</filename> cannot create new partitions automatically. You can later use the <literal>SET INTERVAL</literal> form to enable automatic partition creation.
885+
Specify the interval for range partitioning. When you insert data outside of the existing data range, all new partitions will be created with this interval. If the <literal>INTERVAL</literal> is not specified, <filename>pg_pathman</filename> cannot create new partitions automatically. You can later use the <literal>SET INTERVAL</literal> form to enable automatic partition creation.
886886
</para>
887887
</listitem>
888888
</varlistentry>
@@ -898,8 +898,8 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
898898

899899
<para>
900900
All the forms of ALTER TABLE that act on a single table, except
901-
<literal>RENAME</literal>, and <literal>SET SCHEMA</literal>
902-
can be combined into a list of multiple alterations to applied together.
901+
<literal>RENAME</literal>, <literal>PARTITION BY</literal>, and <literal>SET SCHEMA</literal>,
902+
can be combined into a list of multiple alterations to be applied together.
903903
For example, it
904904
is possible to add several columns and/or alter the type of several
905905
columns in a single command. This is particularly useful with large

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -552,7 +552,7 @@ PARTITION <replaceable class="PARAMETER">partition_name</replaceable> VALUES LES
552552
index on the column or group of columns used in the constraint.
553553
Optional clause <literal>INCLUDE</literal> allows to add into the index
554554
a portion of columns on which the uniqueness is not enforced upon.
555-
Note, that althogh constraint is not enforced upon included columns, it still
555+
Note, that although constraint is not enforced upon included columns, it still
556556
depends on them. Consequently, some operations on these columns (e.g. <literal>DROP COLUMN</literal>)
557557
can cause cascade constraint and index deletion.
558558
See paragraph about <literal>INCLUDE</literal> in
@@ -594,7 +594,7 @@ PARTITION <replaceable class="PARAMETER">partition_name</replaceable> VALUES LES
594594
index on the column or group of columns used in the constraint.
595595
An optional clause <literal>INCLUDE</literal> allows to add into the index
596596
a portion of columns on which the constraint is not enforced upon.
597-
Note, that althogh constraint is not enforced upon included columns, it still
597+
Note, that although constraint is not enforced upon included columns, it still
598598
depends on them. Consequently, some operations on these columns (e.g. <literal>DROP COLUMN</literal>)
599599
can cause cascade constraint and index deletion.
600600
See paragraph about <literal>INCLUDE</literal> in

0 commit comments

Comments
 (0)