postgres.git / summary / log / commit / refs

commit    3a95d2c242eab1efd2ac89d8795ac7a5332c7581
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Mon Nov 27 18:18:03 2023 +0000

    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 cae307470c8..f99052fa5c2 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4029,7 +4029,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: c3b79223f355]