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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2015-12-08 05:36:59 -0800 (Tue, 08 Dec 2015)
New Revision: 9331

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Bugfix for metadata search

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	2015-12-03 16:35:54 UTC (rev 9330)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2015-12-08 13:36:59 UTC (rev 9331)
@@ -729,10 +729,10 @@
 
 FOR featuretype_id_record IN SELECT DISTINCT 
 
-wfs_featuretype.featuretype_id from wfs_featuretype inner join ows_relation_metadata on wfs_featuretype.featuretype_id = ows_relation_metadata.fkey_layer_id where ows_relation_metadata.fkey_metadata_id = $1 and featuretype_searchable = 1
+wfs_featuretype.featuretype_id from wfs_featuretype inner join ows_relation_metadata on wfs_featuretype.featuretype_id = ows_relation_metadata.fkey_featuretype_id where ows_relation_metadata.fkey_metadata_id = $1 and featuretype_searchable = 1
 
 LOOP
-featuretype_id_str := featuretype_id_str || featuretype_id_record.layer_id || ',';
+featuretype_id_str := featuretype_id_str || featuretype_id_record.featuretype_id || ',';
 END LOOP ;
 
 featuretype_id_str := trim(trailing ',' from featuretype_id_str);