From 03121cfe76dd3c9c0c51a203af4dc4c83ce9d693 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 27 Oct 2015 08:00:29 -0700 Subject: [PATCH] JBAS-944 replace ROLLBACK with COMMIT Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql index d3f20ac909..48bb9303b1 100644 --- a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql @@ -9311,8 +9311,8 @@ UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_li UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_list, 'e', '', 'i') WHERE tag = '110' AND control_set = 1 AND sf_list ILIKE '%e%'; -ROLLBACK; ---COMMIT; +--ROLLBACK; +COMMIT; -- These need to happen outside of the transaction to avoid this: -- ERROR: cannot ALTER TABLE "record_entry" because it has pending trigger -- 2.11.0