[doc fix] Trivial fix for PG 11 partitioning

Started by Tsunakawa, Takayukiover 7 years ago2 messages
#1Tsunakawa, Takayuki
tsunakawa.takay@jp.fujitsu.com
1 attachment(s)

Hello,

Attached is a trivial documentation fix for PG 11 partitioning, which includes:

* pg_partition fails to mention hash for the strategy.
* Partitioning key column values can now be modified, which results in row movement between partitions.

Regards
Takayuki Tsunakawa

Attachments:

partition_doc_fix.patchapplication/octet-stream; name=partition_doc_fix.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 26984b6..969ba1b 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -4823,8 +4823,8 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</replaceable>:<replaceable>&l
       <entry><type>char</type></entry>
       <entry></entry>
       <entry>
-       Partitioning strategy; <literal>l</literal> = list partitioned table,
-       <literal>r</literal> = range partitioned table
+       Partitioning strategy; <literal>h</literal> = hash partitioned table,
+       <literal>l</literal> = list partitioned table, <literal>r</literal> = range partitioned table
       </entry>
      </row>
 
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 763b4f5..2a1eac9 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -408,9 +408,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
      <para>
       Rows inserted into a partitioned table will be automatically routed to
       the correct partition.  If no suitable partition exists, an error will
-      occur.  Also, if updating a row in a given partition would require it
-      to move to another partition due to new partition key values, an error
-      will occur.
+      occur.
      </para>
 
      <para>
#2Robert Haas
robertmhaas@gmail.com
In reply to: Tsunakawa, Takayuki (#1)
Re: [doc fix] Trivial fix for PG 11 partitioning

On Fri, May 4, 2018 at 9:53 PM, Tsunakawa, Takayuki
<tsunakawa.takay@jp.fujitsu.com> wrote:

Attached is a trivial documentation fix for PG 11 partitioning, which includes:

* pg_partition fails to mention hash for the strategy.
* Partitioning key column values can now be modified, which results in row movement between partitions.

Committed, thanks.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company