From 8708a6caaf1c45bb6bd9cea17aabc52d92ca9942 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 20 Apr 2015 10:33:21 -0700 Subject: [PATCH] JBAS-495 2.5 upgrade more logs/debugging Signed-off-by: Bill Erickson --- KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql index ff3f2af36f..2023a03301 100644 --- a/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql +++ b/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql @@ -928,7 +928,7 @@ BEGIN RAISE NOTICE 'Cannot bump config.metabib_field.id from % to %; the target ID already exists.', v_source, target_id; RETURN 0; END IF; - RAISE NOTICE 'Updating values for config.metabib_field % => %', v_source, target_id; + RAISE NOTICE 'Updating values for config.metabib_field % => % : %', v_source, target_id, clock_timestamp(); UPDATE config.metabib_field SET id = target_id WHERE id = v_source; EXECUTE ' UPDATE metabib.' || f_class || '_field_entry SET field = ' || target_id || ' WHERE field = ' || v_source; UPDATE config.metabib_field_ts_map SET metabib_field = target_id WHERE metabib_field = v_source; @@ -950,7 +950,8 @@ BEGIN -- PERFORM instead of SELECT to avoid echoing millions of 1's PERFORM config.modify_metabib_field(id, NULL) FROM config.metabib_field - WHERE id > 31; -- KCLS: 31 already back-ported + WHERE id > 31 -- KCLS: 31 already back-ported + ORDER BY id; -- for consistent upgrade path END $$; SELECT SETVAL('config.metabib_field_id_seq', GREATEST(1000, (SELECT MAX(id) FROM config.metabib_field))); -- 2.11.0