SF.net SVN: ledger-smb:[5767] trunk/sql

[..hidden..]

Revision: 5767
          http://sourceforge.net/p/ledger-smb/code/5767
Author:   einhverfr
Date:     2013-05-11 09:03:04 +0000 (Sat, 11 May 2013)
Log Message:
-----------
Two changes:
1.  menu_rebuild now runs in a transaction for safety and
2.  Removed one bad sequence rebuild statement

Modified Paths:
--------------
    trunk/sql/modules/menu_rebuild.sql
    trunk/sql/upgrade/1.3-1.4.sql

Modified: trunk/sql/modules/menu_rebuild.sql
===================================================================
--- trunk/sql/modules/menu_rebuild.sql	2013-05-11 08:26:01 UTC (rev 5766)
+++ trunk/sql/modules/menu_rebuild.sql	2013-05-11 09:03:04 UTC (rev 5767)
@@ -1,7 +1,7 @@
 --
 -- PostgreSQL database dump
 --
-
+begin;
 SET statement_timeout = 0;
 SET client_encoding = 'UTF8';
 SET standard_conforming_strings = on;
@@ -1104,4 +1104,4 @@
 --
 -- PostgreSQL database dump complete
 --
-
+commit;

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2013-05-11 08:26:01 UTC (rev 5766)
+++ trunk/sql/upgrade/1.3-1.4.sql	2013-05-11 09:03:04 UTC (rev 5767)
@@ -650,7 +650,6 @@
  SELECT setval('menu_node_id_seq', max(id)) FROM menu_node;
  SELECT setval('menu_attribute_id_seq', max(id)) FROM menu_attribute;
  SELECT setval('menu_acl_id_seq', max(id)) FROM menu_acl;
- SELECT setval('pending_job_id_seq', max(id)) FROM pending_job;
  SELECT setval('new_shipto_id_seq', max(id)) FROM new_shipto;
  SELECT setval('payment_id_seq', max(id)) FROM payment;
  SELECT setval('cr_report_id_seq', max(id)) FROM cr_report;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.