From a9dc8e661b7ab4e0ec7e5ae777202ca41be2418d Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 15 Jul 2016 16:09:56 -0400 Subject: [PATCH] LP#1599634 - Remove DROP VIEW statement, add .sql to name. When running the upgrade script, the DROP VIEW statement resulted in an error since the view did not already exist. You could add IF EXISTS, but CREATE OR REPLACE VIEW is sufficient. Signed-off-by: Chris Sharp --- ..._Circulation_report_source_to_include_in-house_and_non_cat_circ.sql} | 2 -- 1 file changed, 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ => XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ b/Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ rename to Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql index 8042c32740..76061cc486 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql @@ -2,8 +2,6 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); -DROP VIEW action.all_circulation_combined_types; - CREATE OR REPLACE VIEW action.all_circulation_combined_types AS SELECT 'regularcirc'::text || acirc.id AS id, acirc.xact_start, -- 2.11.0