[Mapbender-commits] r9859 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-02-06 01:13:13 -0800 (Tue, 06 Feb 2018)
New Revision: 9859

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Alter dataset to metadata cause metadata may also be service metadata

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2018-02-06 09:05:12 UTC (rev 9858)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2018-02-06 09:13:13 UTC (rev 9859)
@@ -2299,13 +2299,13 @@
 CREATE OR REPLACE FUNCTION f_get_responsible_organization_for_ressource(i_ressource_id integer, s_ressource_type varchar)
   RETURNS integer AS
 $BODY$DECLARE
-  -- s_ressource_type is 'dataset', 'wms' or 'wfs'
-  -- select f_get_responsible_organization_for_ressource(1,'dataset');
+  -- s_ressource_type is 'metadata', 'wms' or 'wfs'
+  -- select f_get_responsible_organization_for_ressource(1,'metadata');
   i_resp_orga_id INTEGER;
 
 BEGIN
 
-IF s_ressource_type='dataset' THEN 
+IF s_ressource_type='metadata' THEN 
      i_resp_orga_id := fkey_mb_group_id FROM mb_metadata WHERE metadata_id = i_ressource_id;
      IF i_resp_orga_id IS NULL THEN
         --get primary group for fkey_user_id