[doc fix] Trivial fix for PG 11 partitioning
Started by Tsunakawa, Takayukiover 7 years ago2 messages
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><iteration count></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>
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