Skip site navigation (1) Skip section navigation (2)

Re: Documentation improvements for partitioning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Documentation improvements for partitioning
Date: 2017-03-10 01:23:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On 2017/03/10 3:26, Robert Haas wrote:
> I think you might have the titles for 0002 and 0003 backwards.

Oops, you're right.

> On Fri, Mar 3, 2017 at 2:51 AM, Amit Langote wrote:
>> 0002: some cosmetic fixes to create_table.sgml
> I think this sentence may be unclear to some readers:
> + One might however want to set it for only some partitions,
> +      which is possible by doing <literal>SET NOT NULL</literal> on individual
> +      partitions.
> I think you could replace this with something like: Even if there is
> no <literal>NOT NULL</> constraint on the parent, such a constraint
> can still be added to individual partitions, if desired; that is, the
> children can disallow nulls even if the parent allows them, but not
> the other way around.

Reads much better, done that way.  Thanks.

>> 0003: add clarification about NOT NULL constraint on partition columns in
>>       alter_table.sgml
> This is about list-ifying a note, but I think we should try to
> de-note-ify it.  It's a giant block of text that is not obviously more
> noteworthy than the surrounding text; I think <note> should be saved
> for things that particularly need to be called out.

OK.  The patch is now just about de-note-ifying the block of text.  Since
I don't see any other lists in the Parameters portion of the page, I also
take back my list-ifying proposal.

Attached updated patches.


Attachment: 0001-Rewrite-sections-in-ddl.sgml-related-to-partitioning.patch
Description: text/x-diff (61.9 KB)
Attachment: 0002-Add-a-note-about-DROP-NOT-NULL-and-partitions.patch
Description: text/x-diff (1.5 KB)
Attachment: 0003-Listify-a-note-on-the-CREATE-TABLE-page.patch
Description: text/x-diff (4.7 KB)

In response to


pgsql-hackers by date

Next:From: Michael PaquierDate: 2017-03-10 01:26:22
Subject: Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Previous:From: Stephen FrostDate: 2017-03-10 01:04:33
Subject: Re: GSOC Introduction / Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group