X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/8db6dd995a275c38afe606bf8311573680b59ed4..4a8b78985bc0b20b67204633a776a8eb60eba02c:/docs/admin/Migration.md diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index be7d90ff..dc2e2f37 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -27,7 +27,7 @@ therefore either remove traffic from the machine before attempting a version update or create the index manually **before** starting the update using the following SQL: -``` +```sql CREATE INDEX IF NOT EXISTS idx_placex_geometry_reverse_lookupPlaceNode ON placex USING gist (ST_Buffer(geometry, reverse_place_diameter(rank_search))) WHERE rank_address between 4 and 25 AND type != 'postcode'