view schema/updates/1204/02.delete-contours.sql @ 5560:f2204f91d286

Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents c657dec6b0fa
children
line wrap: on
line source

DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_differences'::regclass;
DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_results_contour_lines_geoserver'::regclass;

DROP VIEW waterway.sounding_results_contour_lines_geoserver;
DROP VIEW waterway.sounding_differences;
DROP TABLE caching.sounding_differences_contour_lines;
DROP TABLE waterway.sounding_results_contour_lines;