v1-0001-Update-ddl.sgml-to-reflect-features-added-in-8b08.patch

text/plain

Filename: v1-0001-Update-ddl.sgml-to-reflect-features-added-in-8b08.patch
Type: text/plain
Part: 0
Message: Re: pgsql: Local partitioned indexes

Patch

Format: format-patch
Series: patch v1-0001
Subject: Update ddl.sgml to reflect features added in 8b08f7d4820
File+
doc/src/sgml/ddl.sgml 15 6
From 2007545c0d1c1cdfac079161a108a086091e8735 Mon Sep 17 00:00:00 2001
From: amit <amitlangote09@gmail.com>
Date: Mon, 29 Jan 2018 16:59:03 +0900
Subject: [PATCH v1] Update ddl.sgml to reflect features added in 8b08f7d4820

---
 doc/src/sgml/ddl.sgml | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 1e1f3428a6..9959e7ae6c 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -3159,6 +3159,18 @@ CREATE INDEX ON measurement_y2007m12 (logdate);
 CREATE INDEX ON measurement_y2008m01 (logdate);
 </programlisting>
       </para>
+
+      <para>
+       Alternatively, you can simply create the index in the parent table,
+       which is same as creating it in every partition that is currently
+       defined.  Moreover, once created in the parent table, the index is
+       automatically created in partitions that will be added in the future.
+      </para>
+
+<programlisting>
+CREATE INDEX ON measurement (logdate);
+</programlisting>
+      </para>
      </listitem>
 
       <listitem>
@@ -3273,12 +3285,9 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02
     <itemizedlist>
      <listitem>
       <para>
-       There is no facility available to create the matching indexes on all
-       partitions automatically.  Indexes must be added to each partition with
-       separate commands.  This also means that there is no way to create a
-       primary key, unique constraint, or exclusion constraint spanning all
-       partitions; it is only possible to constrain each leaf partition
-       individually.
+       There is no way to create a primary key, unique constraint, or
+       exclusion constraint spanning all partitions; it is only possible
+       to constrain each leaf partition individually.
       </para>
      </listitem>
 
-- 
2.11.0