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