From 9c152a030a9af829012f679e74625bd139bfb558 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sat, 19 Nov 2022 21:53:14 +0100 Subject: [PATCH] fix condition under which place_to_be_deleted is created It is needed for updates, independently if reverse-only is set. --- lib-sql/indices.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/lib-sql/indices.sql b/lib-sql/indices.sql index 54e88fd8..9130fb52 100644 --- a/lib-sql/indices.sql +++ b/lib-sql/indices.sql @@ -56,6 +56,15 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode --- CREATE UNIQUE INDEX IF NOT EXISTS idx_place_osm_unique ON place USING btree(osm_id, osm_type, class, type) {{db.tablespace.address_index}}; +--- +-- Table needed for running updates with osm2pgsql on place. + CREATE TABLE IF NOT EXISTS place_to_be_deleted ( + osm_type CHAR(1), + osm_id BIGINT, + class TEXT, + type TEXT, + deferred BOOLEAN + ); {% endif %} -- Indices only needed for search. @@ -82,14 +91,5 @@ CREATE INDEX IF NOT EXISTS idx_postcode_postcode INCLUDE (startnumber, endnumber) {{db.tablespace.search_index}} WHERE startnumber is not null; {% endif %} ---- --- Table needed for running updates with osm2pgsql on place. - CREATE TABLE IF NOT EXISTS place_to_be_deleted ( - osm_type CHAR(1), - osm_id BIGINT, - class TEXT, - type TEXT, - deferred BOOLEAN - ); {% endif %} -- 2.39.5