From bc63f10057dd3a9b2c6abd300072f2068415d3f2 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 30 Jun 2022 09:19:16 +0200 Subject: [PATCH] fix syntax error with tablespaces --- lib-sql/indices.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index 332cbb00..9bbc7527 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -63,12 +63,12 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode {% if postgres.has_index_non_key_column %} CREATE INDEX IF NOT EXISTS idx_placex_housenumber - ON placex USING btree (parent_place_id) {{db.tablespace.search_index}} - INCLUDE (housenumber) + ON placex USING btree (parent_place_id) + INCLUDE (housenumber) {{db.tablespace.search_index}} WHERE housenumber is not null; CREATE INDEX IF NOT EXISTS idx_osmline_parent_osm_id_with_hnr - ON location_property_osmline USING btree(parent_place_id) {{db.tablespace.search_index}} - INCLUDE (startnumber, endnumber) + ON location_property_osmline USING btree(parent_place_id) + INCLUDE (startnumber, endnumber) {{db.tablespace.search_index}} WHERE startnumber is not null; {% endif %} {% endif %} -- 2.39.5