truncate road partition tables during load

[nominatim.git] / utils / setup.php

diff --git a/utils/setup.php b/utils/setup.php
index 9a238628e68522493383de8413e17620906388cd..c655eac053e11ecc0d4bff5df4e59b95b9a83f75 100755 (executable)
--- a/utils/setup.php
+++ b/utils/setup.php
@@ -270,6 +270,19 @@
                if (!pg_query($oDB->connection, 'CREATE SEQUENCE seq_place start 100000')) fail(pg_last_error($oDB->connection));
                echo '.';
 
                if (!pg_query($oDB->connection, 'CREATE SEQUENCE seq_place start 100000')) fail(pg_last_error($oDB->connection));
                echo '.';
 

+               $sSQL = 'select partition from country_name order by country_code';
+               $aPartitions = $oDB->getCol($sSQL);
+               if (PEAR::isError($aPartitions))
+               {
+                       fail($aPartitions->getMessage());
+               }
+               $aPartitions[] = 0;
+               foreach($aPartitions as $sPartition)
+               {
+                       if (!pg_query($oDB->connection, 'TRUNCATE location_road_'.$sPartition)) fail(pg_last_error($oDB->connection));
+                       echo '.';
+               }
+

                // pre-create the word list
                if (!$aCMDResult['disable-token-precalc'])
                {
                // pre-create the word list
                if (!$aCMDResult['disable-token-precalc'])
                {