Commitbc22bd2

committed

Fix CREATE INDEX CONCURRENTLY example

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

1 parentd7ca920 commitbc22bd2Copy full SHA for bc22bd2

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4175,7 +4175,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02`
`4175`	`4175`	`<programlisting>`
`4176`	`4176`	`CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);`
`4177`	`4177`
`4178`		`-CREATE INDEX measurement_usls_200602_idx`
	`4178`	`+CREATE INDEXCONCURRENTLYmeasurement_usls_200602_idx`
`4179`	`4179`	`ON measurement_y2006m02 (unitsales);`
`4180`	`4180`	`ALTER INDEX measurement_usls_idx`
`4181`	`4181`	`ATTACH PARTITION measurement_usls_200602_idx;`

Comments

(0)