pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCONCURRENTLY in example of index of partitioned table
2+ messages / 2 participants
[nested] [flat]
* CONCURRENTLY in example of index of partitioned table
@ 2023-11-27 14:57 Nikolay Samokhvalov <nik@postgres.ai>
0 siblings, 1 reply; 2+ messages in thread
From: Nikolay Samokhvalov @ 2023-11-27 14:57 UTC (permalink / raw)
To: 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;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CONCURRENTLY in example of index of partitioned table
@ 2023-11-27 18:02 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Nikolay Samokhvalov <nik@postgres.ai>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2023-11-27 18:02 UTC (permalink / raw)
To: Nikolay Samokhvalov <nik@postgres.ai>; +Cc: pgsql-docs
On 2023-Nov-27, Nikolay Samokhvalov wrote:
> 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:
You're right, my mistake. Will push shortly.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-11-27 18:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-27 14:57 CONCURRENTLY in example of index of partitioned table Nikolay Samokhvalov <nik@postgres.ai>
2023-11-27 18:02 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox