postgres.git / summary / log / commit / refs

commit    fef92f9ba10175bab6af4307c54ce450a592a2e7
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 cfe3dcbd392..fc0087c6cd3 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4150,7 +4150,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: a77fb8c68549]