From de1a89faeaf26df79102a1dd8b0056af9b633876 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 18 Sep 2017 21:03:15 -0400 Subject: [PATCH] Drop view before adding/replacing it. --- Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql index 7c7f90e4b1..26c8a74343 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql @@ -5,6 +5,9 @@ INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.0-beta1', :eg_ve 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