Mercurial > gemma

comparison schema/updates/1441/01.extend_sounding_result_view.sql @ 5311:72d3b8321ed0 zpg-exception

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed broken migration which erased the style of the modified GeoServer view.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 02 Jun 2021 16:55:00 +0200
parents 4ba3fda13c50
children
comparison
equal deleted inserted replaced
5310:660147046ddd 5311:72d3b8321ed0
1 -- Could have used an UPDATE for this but this way its more C&P from 1 UPDATE sys_admin.published_services SET view_def = $$
2 -- default_sysconfig.sql 2 SELECT bottleneck_id,
3 3 to_char(date_info, 'YYYY-MM-DD') AS date_info,
4 DELETE FROM sys_admin.published_services 4 height,
5 areas,
6 surtyp,
7 zpg_exception
8 FROM waterway.sounding_results_iso_areas ia
9 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
10 $$
5 WHERE schema = 'waterway' AND name = 'sounding_results_areas_geoserver'; 11 WHERE schema = 'waterway' AND name = 'sounding_results_areas_geoserver';
6
7 INSERT INTO sys_admin.published_services (
8 schema, name, srid, key_column, view_def
9 ) VALUES
10 ('waterway', 'sounding_results_areas_geoserver', 4326, NULL, $$
11 SELECT bottleneck_id,
12 to_char(date_info, 'YYYY-MM-DD') AS date_info,
13 height,
14 areas,
15 surtyp,
16 zpg_exception
17 FROM waterway.sounding_results_iso_areas ia
18 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
19 $$);