Commit2c4dd36

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 parent09f680d commit2c4dd36Copy full SHA for 2c4dd36

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4026,7 +4026,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02`
`4026`	`4026`	`<programlisting>`
`4027`	`4027`	`CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);`
`4028`	`4028`
`4029`		`-CREATE INDEX measurement_usls_200602_idx`
	`4029`	`+CREATE INDEXCONCURRENTLYmeasurement_usls_200602_idx`
`4030`	`4030`	`ON measurement_y2006m02 (unitsales);`
`4031`	`4031`	`ALTER INDEX measurement_usls_idx`
`4032`	`4032`	`ATTACH PARTITION measurement_usls_200602_idx;`

Comments

(0)