[Aplaws-commit] r1119 - trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade

[<ssk...@vh...>]

Author: sskracic
Date: 2006-04-25 15:47:33 +0200 (Tue, 25 Apr 2006)
New Revision: 1119

Modified:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql
Log:
  Yeah, Postgres is weird, it needs 'commit' to persist DDL changes as well.


Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql	2006-04-24 02:57:44 UTC (rev 1118)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql	2006-04-25 13:47:33 UTC (rev 1119)
@@ -1,8 +1,12 @@
-alter table ldn_dublin_core_items add
-  item_id integer constraint ldn_dub_cor_ite_ite_id_f_f7q6_ references cms_items(item_id);
-update ldn_dublin_core_items
-  set item_id = dcm.item_id
-  from LDN_DUBLIN_CORE_ITEM_MAP dcm
-  where dcm.dublin_id=ldn_dublin_core_items.dublin_id;
+begin;
 
--- drop table ldn_dublin_core_item_map;
+  alter table ldn_dublin_core_items add
+    item_id integer constraint ldn_dub_cor_ite_ite_id_f_f7q6_ references cms_items(item_id);
+  update ldn_dublin_core_items
+    set item_id = dcm.item_id
+    from LDN_DUBLIN_CORE_ITEM_MAP dcm
+    where dcm.dublin_id=ldn_dublin_core_items.dublin_id;
+
+  -- drop table ldn_dublin_core_item_map;
+
+commit;