Commit8a553f2

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 parenta82ee7e commit8a553f2Copy full SHA for 8a553f2

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4222,7 +4222,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02`
`4222`	`4222`	`<programlisting>`
`4223`	`4223`	`CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);`
`4224`	`4224`
`4225`		`-CREATE INDEX measurement_usls_200602_idx`
	`4225`	`+CREATE INDEXCONCURRENTLYmeasurement_usls_200602_idx`
`4226`	`4226`	`ON measurement_y2006m02 (unitsales);`
`4227`	`4227`	`ALTER INDEX measurement_usls_idx`
`4228`	`4228`	`ATTACH PARTITION measurement_usls_200602_idx;`

Comments

(0)