From 04b20a68a4376d8cb0e2be1d1b2876edc2d08b87 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 17 Sep 2012 07:56:43 -0400 Subject: [PATCH] transactionalizing scripts --- .../src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-parallel-1.sql | 4 ++++ Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-pt-1.sql | 5 +++-- 2 files changed, 7 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-parallel-1.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-parallel-1.sql index 611f66c25f..b1a563a3ff 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-parallel-1.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-parallel-1.sql @@ -1,3 +1,6 @@ +\set eg_version '''2.2.0''' + +BEGIN; -- Evergreen DB patch 0663.schema.archive_circ_stat_cats.sql -- -- Enables users to set copy and patron stat cats to be archivable @@ -102,4 +105,5 @@ ALTER TABLE action.circulation ALTER COLUMN copy_location SET DEFAULT 1, ENABLE TRIGGER ALL; +COMMIT; diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-pt-1.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-pt-1.sql index 1257f30340..f5143d98f3 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-pt-1.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade-pt-1.sql @@ -118,9 +118,9 @@ Upgrade script % can not be applied: END; $$ LANGUAGE PLPGSQL; - Evergreen DB patch 0536.schema.lazy_circ-barcode_lookup.sql +-- Evergreen DB patch 0536.schema.lazy_circ-barcode_lookup.sql - FIXME: insert description of change, if needed +-- FIXME: insert description of change, if needed -- check whether patch can be applied @@ -523,3 +523,4 @@ INSERT INTO config.org_unit_setting_type ( name, label, description, datatype ) ), 'integer' ); +COMMIT; -- 2.11.0