From ede8461d83c5d4c1ec0f7535656c112df3cfdbf7 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 1 Mar 2016 15:39:23 -0500 Subject: [PATCH] LP#1549505: fix issues preventing filter precalc functions from installing Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index af12c19de6..d91bcc80d2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -6,6 +6,9 @@ BEGIN; DROP VIEW reporter.hold_request_record; +CREATE TEMP TABLE precalc_attr_filter_bib_list ON COMMIT DROP AS + SELECT source AS id FROM metabib.record_attr_vector_list LIMIT 0; + CREATE TABLE reporter.hold_request_record AS SELECT id, target, @@ -340,6 +343,7 @@ DECLARE afilter TEXT := 0; BEGIN + SET client_min_messages = error; DROP TABLE IF EXISTS precalc_attr_filter_bib_list; IF attr_filter IS NOT NULL THEN afilter := metabib.compile_composite_attr(attr_filter); @@ -349,7 +353,7 @@ BEGIN ELSE CREATE TEMP TABLE precalc_attr_filter_bib_list ON COMMIT DROP AS SELECT source AS id FROM metabib.record_attr_vector_list; - END IF + END IF; CREATE INDEX precalc_attr_filter_bib_list_idx ON precalc_attr_filter_bib_list (id); -- 2.11.0