[Mapbender-commits] r4531 - in branches/2.6/resources/db/pgsql: ISO-8859-1 UTF-8

[svn_mapbender at osgeo.org]

Author: tbaschetti
Date: 2009-08-26 04:37:04 -0400 (Wed, 26 Aug 2009)
New Revision: 4531

Modified:
   branches/2.6/resources/db/pgsql/ISO-8859-1/pgsql_data_2.5.sql
   branches/2.6/resources/db/pgsql/UTF-8/pgsql_data_2.5.sql
Log:
changed disable/enable trigger for postgres 8.4
http://trac.osgeo.org/mapbender/ticket/508



Modified: branches/2.6/resources/db/pgsql/ISO-8859-1/pgsql_data_2.5.sql
===================================================================
--- branches/2.6/resources/db/pgsql/ISO-8859-1/pgsql_data_2.5.sql	2009-08-25 17:20:24 UTC (rev 4530)
+++ branches/2.6/resources/db/pgsql/ISO-8859-1/pgsql_data_2.5.sql	2009-08-26 08:37:04 UTC (rev 4531)
@@ -9,7 +9,45 @@
 -- PostgreSQL database dump
 --
 
-UPDATE pg_catalog.pg_class SET reltriggers = 0;
+-- disable all triggers
+--UPDATE pg_catalog.pg_class SET reltriggers = 0;
+alter table gui disable trigger all;
+alter table gui_element disable trigger all;
+alter table gui_element_vars disable trigger all;
+alter table gui_kml disable trigger all;
+alter table gui_layer disable trigger all;
+alter table gui_mb_group disable trigger all;
+alter table gui_mb_user disable trigger all;
+alter table gui_treegde disable trigger all;
+alter table gui_wfs disable trigger all;
+alter table gui_wfs_conf disable trigger all;
+alter table gui_wms disable trigger all;
+alter table keyword disable trigger all;
+alter table layer disable trigger all;
+alter table layer_epsg disable trigger all;
+alter table layer_keyword disable trigger all;
+alter table layer_load_count disable trigger all;
+alter table layer_style disable trigger all;
+alter table mb_group disable trigger all;
+alter table mb_log disable trigger all;
+alter table mb_monitor disable trigger all;
+alter table mb_user disable trigger all;
+alter table mb_user_mb_group disable trigger all;
+alter table mb_user_wmc disable trigger all;
+alter table md_topic_category disable trigger all;
+alter table sld_user_layer disable trigger all;
+alter table translations disable trigger all;
+alter table wfs disable trigger all;
+alter table wfs_conf disable trigger all;
+alter table wfs_conf_element disable trigger all;
+alter table wfs_element disable trigger all;
+alter table wfs_featuretype disable trigger all;
+alter table wfs_featuretype_keyword disable trigger all;
+alter table wfs_featuretype_namespace disable trigger all;
+alter table wms disable trigger all;
+alter table wms_format disable trigger all;
+alter table wms_md_topic_category disable trigger all;
+alter table wms_srs disable trigger all;
 
 --
 -- Data for Name: gui; Type: TABLE DATA; Schema: public; Owner: admin
@@ -22504,4 +22542,42 @@
 -- PostgreSQL database dump complete
 --
 
-UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid); 
+-- reenable all triggers
+--UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid); 
+alter table gui enable trigger all;
+alter table gui_element enable trigger all;
+alter table gui_element_vars enable trigger all;
+alter table gui_kml enable trigger all;
+alter table gui_layer enable trigger all;
+alter table gui_mb_group enable trigger all;
+alter table gui_mb_user enable trigger all;
+alter table gui_treegde enable trigger all;
+alter table gui_wfs enable trigger all;
+alter table gui_wfs_conf enable trigger all;
+alter table gui_wms enable trigger all;
+alter table keyword enable trigger all;
+alter table layer enable trigger all;
+alter table layer_epsg enable trigger all;
+alter table layer_keyword enable trigger all;
+alter table layer_load_count enable trigger all;
+alter table layer_style enable trigger all;
+alter table mb_group enable trigger all;
+alter table mb_log enable trigger all;
+alter table mb_monitor enable trigger all;
+alter table mb_user enable trigger all;
+alter table mb_user_mb_group enable trigger all;
+alter table mb_user_wmc enable trigger all;
+alter table md_topic_category enable trigger all;
+alter table sld_user_layer enable trigger all;
+alter table translations enable trigger all;
+alter table wfs enable trigger all;
+alter table wfs_conf enable trigger all;
+alter table wfs_conf_element enable trigger all;
+alter table wfs_element enable trigger all;
+alter table wfs_featuretype enable trigger all;
+alter table wfs_featuretype_keyword enable trigger all;
+alter table wfs_featuretype_namespace enable trigger all;
+alter table wms enable trigger all;
+alter table wms_format enable trigger all;
+alter table wms_md_topic_category enable trigger all;
+alter table wms_srs enable trigger all;

Modified: branches/2.6/resources/db/pgsql/UTF-8/pgsql_data_2.5.sql
===================================================================
--- branches/2.6/resources/db/pgsql/UTF-8/pgsql_data_2.5.sql	2009-08-25 17:20:24 UTC (rev 4530)
+++ branches/2.6/resources/db/pgsql/UTF-8/pgsql_data_2.5.sql	2009-08-26 08:37:04 UTC (rev 4531)
@@ -12,7 +12,45 @@
 -- PostgreSQL database dump
 --
 
-UPDATE pg_catalog.pg_class SET reltriggers = 0;
+-- disable all triggers
+--UPDATE pg_catalog.pg_class SET reltriggers = 0;
+alter table gui disable trigger all;
+alter table gui_element disable trigger all;
+alter table gui_element_vars disable trigger all;
+alter table gui_kml disable trigger all;
+alter table gui_layer disable trigger all;
+alter table gui_mb_group disable trigger all;
+alter table gui_mb_user disable trigger all;
+alter table gui_treegde disable trigger all;
+alter table gui_wfs disable trigger all;
+alter table gui_wfs_conf disable trigger all;
+alter table gui_wms disable trigger all;
+alter table keyword disable trigger all;
+alter table layer disable trigger all;
+alter table layer_epsg disable trigger all;
+alter table layer_keyword disable trigger all;
+alter table layer_load_count disable trigger all;
+alter table layer_style disable trigger all;
+alter table mb_group disable trigger all;
+alter table mb_log disable trigger all;
+alter table mb_monitor disable trigger all;
+alter table mb_user disable trigger all;
+alter table mb_user_mb_group disable trigger all;
+alter table mb_user_wmc disable trigger all;
+alter table md_topic_category disable trigger all;
+alter table sld_user_layer disable trigger all;
+alter table translations disable trigger all;
+alter table wfs disable trigger all;
+alter table wfs_conf disable trigger all;
+alter table wfs_conf_element disable trigger all;
+alter table wfs_element disable trigger all;
+alter table wfs_featuretype disable trigger all;
+alter table wfs_featuretype_keyword disable trigger all;
+alter table wfs_featuretype_namespace disable trigger all;
+alter table wms disable trigger all;
+alter table wms_format disable trigger all;
+alter table wms_md_topic_category disable trigger all;
+alter table wms_srs disable trigger all;
 
 --
 -- Data for Name: gui; Type: TABLE DATA; Schema: public; Owner: admin
@@ -22506,4 +22544,42 @@
 -- PostgreSQL database dump complete
 --
 
-UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid); 
+-- reenable all triggers
+--UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid); 
+alter table gui enable trigger all;
+alter table gui_element enable trigger all;
+alter table gui_element_vars enable trigger all;
+alter table gui_kml enable trigger all;
+alter table gui_layer enable trigger all;
+alter table gui_mb_group enable trigger all;
+alter table gui_mb_user enable trigger all;
+alter table gui_treegde enable trigger all;
+alter table gui_wfs enable trigger all;
+alter table gui_wfs_conf enable trigger all;
+alter table gui_wms enable trigger all;
+alter table keyword enable trigger all;
+alter table layer enable trigger all;
+alter table layer_epsg enable trigger all;
+alter table layer_keyword enable trigger all;
+alter table layer_load_count enable trigger all;
+alter table layer_style enable trigger all;
+alter table mb_group enable trigger all;
+alter table mb_log enable trigger all;
+alter table mb_monitor enable trigger all;
+alter table mb_user enable trigger all;
+alter table mb_user_mb_group enable trigger all;
+alter table mb_user_wmc enable trigger all;
+alter table md_topic_category enable trigger all;
+alter table sld_user_layer enable trigger all;
+alter table translations enable trigger all;
+alter table wfs enable trigger all;
+alter table wfs_conf enable trigger all;
+alter table wfs_conf_element enable trigger all;
+alter table wfs_element enable trigger all;
+alter table wfs_featuretype enable trigger all;
+alter table wfs_featuretype_keyword enable trigger all;
+alter table wfs_featuretype_namespace enable trigger all;
+alter table wms enable trigger all;
+alter table wms_format enable trigger all;
+alter table wms_md_topic_category enable trigger all;
+alter table wms_srs enable trigger all;