X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/dd5cd9771315ec58fad4e3b04cab91a726a8c495..9056c9276fdf2d449abb27c9295a361ce31020ec:/docs/admin/Migration.md?ds=sidebyside 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'