Commit3a95d2c

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 parentc3b7922 commit3a95d2cCopy full SHA for 3a95d2c

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

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

Comments

(0)