| From: | Nikolay Samokhvalov <nik(at)postgres(dot)ai> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | CONCURRENTLY in example of index of partitioned table |
| Date: | 2023-11-27 14:57:24 |
| Message-ID: | CAM527d9iz6+=_c7EqSKaGzjqWvSeCeRVVvHZ1v3gDgjTtvgsbw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
https://www.postgresql.org/docs/current/ddl-partitioning.html provides an
example of using CONCURRENTLY for index creation of partitioned tables; but
it the example itself doesn't have this word; here is a fix:
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index
4490e82aa52f3c0e2039047ab57194933d7c0275..d2951cd754c68237cd97eedd9c4353a671ad0995
100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4222,7 +4222,7 @@ ALTER TABLE measurement ATTACH PARTITION
measurement_y2008m02
<programlisting>
CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);
-CREATE INDEX measurement_usls_200602_idx
+CREATE INDEX CONCURRENTLY measurement_usls_200602_idx
ON measurement_y2006m02 (unitsales);
ALTER INDEX measurement_usls_idx
ATTACH PARTITION measurement_usls_200602_idx;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2023-11-27 15:05:25 | Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS |
| Previous Message | Alvaro Herrera | 2023-11-27 14:22:28 | Re: [DOCS] Add example about date ISO format |