From 7b9c532455f5956edc89b1128c32e5aaa2f01e72 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