Commita5e95ff

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 parent0217a74 commita5e95ffCopy full SHA for a5e95ff

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4020,7 +4020,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02`
`4020`	`4020`	`<programlisting>`
`4021`	`4021`	`CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);`
`4022`	`4022`
`4023`		`-CREATE INDEX measurement_usls_200602_idx`
	`4023`	`+CREATE INDEXCONCURRENTLYmeasurement_usls_200602_idx`
`4024`	`4024`	`ON measurement_y2006m02 (unitsales);`
`4025`	`4025`	`ALTER INDEX measurement_usls_idx`
`4026`	`4026`	`ATTACH PARTITION measurement_usls_200602_idx;`

Comments

(0)