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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-11-11 00:34:20 -0800 (Thu, 11 Nov 2010)
New Revision: 7105

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
do not make postgres owner of new tables

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-11-11 08:32:47 UTC (rev 7104)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-11-11 08:34:20 UTC (rev 7105)
@@ -2362,7 +2362,7 @@
 END;
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE;
-ALTER FUNCTION f_collect_searchtext_wmc(integer) OWNER TO postgres;
+--ALTER FUNCTION f_collect_searchtext_wmc(integer) OWNER TO postgres;
 
 
 
@@ -2446,7 +2446,7 @@
 END;
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE STRICT;
-ALTER FUNCTION f_collect_custom_cat_wmc(integer) OWNER TO postgres;
+--ALTER FUNCTION f_collect_custom_cat_wmc(integer) OWNER TO postgres;
 --functions to collect the categories into strings
 CREATE OR REPLACE FUNCTION f_collect_inspire_cat_wmc(integer)
   RETURNS text AS
@@ -2463,7 +2463,7 @@
 END;
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE STRICT;
-ALTER FUNCTION f_collect_inspire_cat_wmc(integer) OWNER TO postgres;
+--ALTER FUNCTION f_collect_inspire_cat_wmc(integer) OWNER TO postgres;
 
 CREATE OR REPLACE FUNCTION f_collect_topic_cat_wmc(integer)
   RETURNS text AS
@@ -2484,7 +2484,7 @@
 END;
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE STRICT;
-ALTER FUNCTION f_collect_topic_cat_wmc(integer) OWNER TO postgres;
+--ALTER FUNCTION f_collect_topic_cat_wmc(integer) OWNER TO postgres;
 
 --*******wmc end*****
 
@@ -2521,7 +2521,7 @@
   WHERE wmc_dep.wmc_public = 1
   ORDER BY wmc_dep.wmc_id;
 
-ALTER TABLE search_wmc_view OWNER TO postgres;
+--ALTER TABLE search_wmc_view OWNER TO postgres;
 
 
 -- insert deleteWFSConf modul in admin1
@@ -2964,7 +2964,7 @@
 WITH (
   OIDS=FALSE
 );
-ALTER TABLE wmc_preview OWNER TO postgres;
+--ALTER TABLE wmc_preview OWNER TO postgres;
 -- Table wmc_load_count
 
 -- DROP TABLE wmc_load_count;
@@ -2978,7 +2978,7 @@
       ON UPDATE CASCADE ON DELETE CASCADE
 )
 WITH (OIDS=TRUE);
-ALTER TABLE wmc_load_count OWNER TO postgres;
+--ALTER TABLE wmc_load_count OWNER TO postgres;
 
 -- Index: idx_fkey_layer_id