diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2023-11-27 19:18:03 +0100 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2023-11-27 19:18:03 +0100 |
| commit | 2c4dd36e2580a645cf9554b8335907964bf3344b (patch) | |
| tree | cb888764d9a9b09cb765f58bb72b2789a9b1c02b | |
| parent | 09f680d114b5e1372404d0c1e17851a786c6c615 (diff) | |
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
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
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; |