Mercurial > gemma

annotate 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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5311
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
1 UPDATE sys_admin.published_services SET view_def = $$
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
2 SELECT bottleneck_id,
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
3 to_char(date_info, 'YYYY-MM-DD') AS date_info,
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
4 height,
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
5 areas,
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
6 surtyp,
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
7 zpg_exception
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
8 FROM waterway.sounding_results_iso_areas ia
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
9 JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
72d3b8321ed0 Fixed broken migration which erased the style of the modified GeoServer view.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5307
diff changeset
10 $$
5306
6b0274693b48 Extended view for GeoServer to contain zpg_exception.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
11 WHERE schema = 'waterway' AND name = 'sounding_results_areas_geoserver';