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