From bc2624411464260f0eb7b2b0c7e4ad1d7ae63393 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 10 Sep 2018 20:56:49 +0200 Subject: [PATCH] docs: remove tablespace placeholder from index commands Fixes #1171. --- docs/admin/Migration.md | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index e18b3df5..2cc0b80b 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -15,17 +15,17 @@ SQL statements to create the indexes: ``` CREATE INDEX idx_placex_geometry_reverse_lookupPoint - ON placex USING gist (geometry) {ts:search-index} + ON placex USING gist (geometry) WHERE (name is not null or housenumber is not null or rank_address between 26 and 27) AND class not in ('railway','tunnel','bridge','man_made') AND rank_address >= 26 AND indexed_status = 0 AND linked_place_id is null; CREATE INDEX idx_placex_geometry_reverse_lookupPolygon - ON placex USING gist (geometry) {ts:search-index} + ON placex USING gist (geometry) WHERE St_GeometryType(geometry) in ('ST_Polygon', 'ST_MultiPolygon') AND rank_address between 4 and 25 AND type != 'postcode' AND name is not null AND indexed_status = 0 AND linked_place_id is null; CREATE INDEX idx_placex_geometry_reverse_placeNode - ON placex USING gist (geometry) {ts:search-index} + ON placex USING gist (geometry) WHERE osm_type = 'N' AND rank_search between 5 and 25 AND class = 'place' AND type != 'postcode' AND name is not null AND indexed_status = 0 AND linked_place_id is null; -- 2.43.2