postgres.git / summary / log / commit / refs

commit    2c4dd36e2580a645cf9554b8335907964bf3344b
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Mon Nov 27 18:18:03 2023 +0000
First released in: 17.0, 12.18, 13.14, 14.11, 15.6, 16.2

    Fix CREATE INDEX CONCURRENTLY example
    
    It fails to use the CONCURRENTLY keyword where it was necessary, so add
    it.  This text was added to pg11 in commit 5efd604ec0a3; backpatch to pg12.
    
    Author: Nikolay Samokhvalov <nik@postgres.ai>
    Discussion: https://postgr.es/m/CAM527d9iz6+=_c7EqSKaGzjqWvSeCeRVVvHZ1v3gDgjTtvgsbw@mail.gmail.com


 doc/src/sgml/ddl.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index fbabc904c3c..91a2e15b05b 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4026,7 +4026,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;


[parent: 09f680d114b5]