From 356b8262679babe942fcea96c9e628058fc48c9b Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Thu, 6 Mar 2014 17:46:30 -0500 Subject: [PATCH] LP1287967 - drop reporter.classic_current_circ view as part of 0864 upgrade As noted in the bug description, attempts to run 0864.MVF_CRA-upgrade.sql will fail on a database where the reporter.classic_current_circ view is present. Add a DROP VIEW IF EXISTS and then include a note that administrators will need to recreate the VIEW afterwards if desired. Signed-off-by: Ben Shum Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql index 4adbde77fe..4307f90987 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql @@ -139,6 +139,7 @@ INSERT INTO metabib.record_attr_vector_list (source,vlist) WHERE COALESCE(u.id,c.id) IS NOT NULL GROUP BY 1; +DROP VIEW IF EXISTS reporter.classic_current_circ; DROP VIEW metabib.rec_descriptor; DROP TABLE metabib.record_attr; @@ -898,3 +899,6 @@ CREATE OR REPLACE FUNCTION unapi.mra ( $F$ LANGUAGE SQL STABLE; COMMIT; +\qecho 'We dropped reporter.classic_current_circ earlier from the' +\qecho 'example.reporter-extension.sql sample. You will need to' +\qecho 'run it again to recreate that custom reporter view.' -- 2.43.2