From 6bdae820dd53d3aef759adf0ee34ab9287ab1c2e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 1 Nov 2017 15:09:41 -0400 Subject: [PATCH] Drop view before adding/replacing it. --- Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql index 263223d990..434061111a 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql @@ -23,6 +23,9 @@ INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.0.0', :eg_versio SELECT evergreen.upgrade_deps_block_check('1032', :eg_version); -- Bmagic/csharp/gmcharlt +-- PINES: drop view then replace +DROP VIEW IF EXISTS action.all_circulation_combined_types; + CREATE OR REPLACE VIEW action.all_circulation_combined_types AS SELECT acirc.id AS id, acirc.xact_start, -- 2.11.0