| From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> | 
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Documentation improvements for partitioning | 
| Date: | 2017-02-03 09:15:40 | 
| Message-ID: | bf9ebbb3-fb1e-3206-b67c-e7a803a747d9@lab.ntt.co.jp | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Here are some patches to improve the documentation about partitioned tables:
0001: Adds some details about partition_bound_spec to the CREATE TABLE
page, especially:
 - a note about inclusivity of range partition bounds,
 - a note about the UNBOUNDED literal in case of range partitioning,
 - a note about the NULL literal in case of list partitioning,
I wonder if the above "note" should be added under the Notes section or
are they fine to be added as part of the description of PARTITION OF
clause. Also:
 - in syntax synopsis, it appears now that any expression is OK to be used
   for individual bound datum, but it's not true.  Only literals are
   allowed.  So fixed that.
 - added an example showing how to create partitions of a range
   partitioned table with multiple columns in the partition key
 - added PARTITION BY and PARTITION OF (FOR VALUES) as PostgreSQL
   extensions in the compatibility section
0002: Adds details about partitioned tables to the DDL chapter (ddl.sgml)
 - a new section named "Partitioned Tables" right next to the
   Inheritance and Partitioning sections is created.
 - examples are added to the existing Partitioning section using the new
   partitioned tables.  Old text about implementing table partitioning
   using inheritance is kept, sort of as a still supported older
   alternative.
0003: Add partitioning keywords to keywords.sgml
This is all I have for now.  Any feedback is greatly appreciated.  Adding
this to the next CF.
Thanks,
Amit
| Attachment | Content-Type | Size | 
|---|---|---|
| 0001-Improve-CREATE-TABLE-documentation-of-partitioning.patch | text/x-diff | 6.8 KB | 
| 0002-Update-ddl.sgml-for-declarative-partitioning.patch | text/x-diff | 23.5 KB | 
| 0003-Add-partitioning-keywords-to-keywords.sgml.patch | text/x-diff | 1.4 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2017-02-03 09:19:38 | Re: Index corruption with CREATE INDEX CONCURRENTLY | 
| Previous Message | vinayak | 2017-02-03 09:12:01 | Postgres_fdw behaves oddly |