From 6828688209942df3d5f2653accc3b33b10f3e47c Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 5 Nov 2015 15:42:03 +0000 Subject: [PATCH] LP#1464765: (follow-up) remove unneeded bits from schema upgrade The patch for bug 1155313 already corrected the data, so no need to do it again. Signed-off-by: Galen Charlton --- .../src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql | 12 ------------ 1 file changed, 12 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql index dc15874887..3b31f94f94 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql @@ -12,16 +12,4 @@ CREATE OR REPLACE FUNCTION evergreen.lpad_number_substrings( TEXT, TEXT, INT ) R return $string; $$ LANGUAGE PLPERLU; - --- Correct any potentially incorrectly padded sortkeys - -UPDATE biblio.monograph_part SET label = label; - -UPDATE asset.call_number_prefix SET label = label; - --- asset.call_number.label_sortkey doesn't make use of this function - -UPDATE asset.call_number_suffix SET label = label; - COMMIT; - -- 2.11.0