postgres.git / summary / log / commit / refs

commit    a5e95ff46f58c1aa15760ee3b2aa074f695f53d1
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 7dee6a2e2c2..28cb289b767 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4020,7 +4020,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: 0217a7444a57]