[Mapbender-commits] r9526 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2016-06-20 06:56:26 -0700 (Mon, 20 Jun 2016)
New Revision: 9526

Modified:
   trunk/mapbender/resources/db/materialize_wms_view.sql
Log:
Fix for missing tables

Modified: trunk/mapbender/resources/db/materialize_wms_view.sql
===================================================================
--- trunk/mapbender/resources/db/materialize_wms_view.sql	2016-06-20 13:51:19 UTC (rev 9525)
+++ trunk/mapbender/resources/db/materialize_wms_view.sql	2016-06-20 13:56:26 UTC (rev 9526)
@@ -1,7 +1,7 @@
 select * into wms_search_table_tmp from search_wms_view;
 
 
-DROP TABLE wms_search_table;
+DROP TABLE IF EXISTS wms_search_table;
 
 ALTER TABLE wms_search_table_tmp RENAME TO  wms_search_table;
 
@@ -69,9 +69,9 @@
 --vacuum analyze;
 --VACUUM ANALYZE wms_search_table;
 
-DROP TABLE wms_list_tmp;
+DROP TABLE IF EXISTS wms_list_tmp;
 select * into wms_list_tmp from wms_list_view;
-DROP TABLE wms_list;
+DROP TABLE IF EXISTS wms_list;
 ALTER TABLE wms_list_tmp RENAME TO  wms_list;
 
 -- Index: idx_wms_list_wms_id