[Mapbender-commits] r4999 - branches/2.6/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2009-11-17 08:17:40 -0500 (Tue, 17 Nov 2009)
New Revision: 4999

Modified:
   branches/2.6/resources/db/pgsql/UTF-8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
Log:
Changed SQL to IN as more than one result can occur

Modified: branches/2.6/resources/db/pgsql/UTF-8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
===================================================================
--- branches/2.6/resources/db/pgsql/UTF-8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	2009-11-16 17:18:33 UTC (rev 4998)
+++ branches/2.6/resources/db/pgsql/UTF-8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	2009-11-17 13:17:40 UTC (rev 4999)
@@ -2,7 +2,7 @@
 -- database changes in version 2.5.1
 --
 
-DELETE FROM wfs_conf_element WHERE f_id = ((SELECT DISTINCT f_id FROM wfs_conf_element) EXCEPT (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id));
+DELETE FROM wfs_conf_element WHERE f_id IN ((SELECT DISTINCT f_id FROM wfs_conf_element) EXCEPT (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id));
 
 ALTER TABLE ONLY wfs_element
     ADD CONSTRAINT wfs_element_element_id_key UNIQUE (element_id);