From ee6a8b602cf59f548f536ae42ce21f6eb2827f8c Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 7 Sep 2011 14:05:25 -0400 Subject: [PATCH] Make sure that title and author sorting data is available after a 2.0-2.1 upgrade Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) diff --git a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql index 376bc08c8c..605dfa3886 100644 --- a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql @@ -8785,4 +8785,21 @@ CREATE TRIGGER mat_summary_upd_tgr AFTER UPDATE ON money.check_payment FOR EACH CREATE TRIGGER mat_summary_del_tgr BEFORE DELETE ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_del ('check_payment'); +UPDATE metabib.record_attr + SET attrs = attrs || asort + FROM (SELECT record, + HSTORE('authorsort',FIRST(value)) AS asort + FROM metabib.full_rec + WHERE tag like '1%' + GROUP BY 1) x + WHERE x.record = metabib.record_attr.id; + +UPDATE metabib.record_attr + SET attrs = attrs || tsort + FROM (SELECT record, + HSTORE('titlesort',FIRST(value)) AS tsort + FROM metabib.full_rec + WHERE tag = 'tnf' + GROUP BY 1) x + WHERE x.record = metabib.record_attr.id; -- 2.11.0