On 2018/07/17 13:57, Alvaro Herrera wrote:
> On 2018-Feb-19, David G. Johnston wrote:
>
>> As an aside, adding a link to "Data Definiton/Table Partitioning" from at
>> least CREATE TABLE ... PARTITION BY; and swapping "PARTITION BY" and
>> "PARTITION OF" in the Parameters section of that page -
On 2018-Feb-19, David G. Johnston wrote:
> As an aside, adding a link to "Data Definiton/Table Partitioning" from at
> least CREATE TABLE ... PARTITION BY; and swapping "PARTITION BY" and
> "PARTITION OF" in the Parameters section of that page - one must partition
> by a table before one can
David G. Johnston wrote:
> Something like:
>
> When establishing a unique constraint for a multi-level partition hierarchy
> all the "partition by" columns of the target partitioned table, as well as
> those of all its descendant partitioned tables, must be included in the
> constraint
David Rowley wrote:
> On 20 February 2018 at 09:40, Alvaro Herrera wrote:
> > Modified Files
> > --
> > doc/src/sgml/ddl.sgml | 9 +-
>
> Attached is a very small fix to a small error this patch created in the docs.
Pushed, thanks.
On Tue, Feb 20, 2018 at 8:36 AM, Alvaro Herrera
wrote:
> Many thanks for reading through it!
>
> David G. Johnston wrote:
> > I found the following change to be confusing.
> [...]
> > I was expecting the doc for ADD CONSTRAINT USING INDEX to note the
> > limitation
Many thanks for reading through it!
David G. Johnston wrote:
> I found the following change to be confusing.
[...]
> I was expecting the doc for ADD CONSTRAINT USING INDEX to note the
> limitation explicitly - in lieu of the above paragraph.
Agreed. I moved the note to ADD CONSTRAINT and added
I found the following change to be confusing.
/doc/src/sgml/ref/alter_table.sgml
+
+Additional restrictions apply when unique indexes are applied to
+partitioned tables; see .
+
That paragraph appears in the section covering "ALTER TABLE name ADD