LP#1599634 - Remove DROP VIEW statement, add .sql to name.
authorChris Sharp <csharp@georgialibraries.org>
Fri, 15 Jul 2016 20:09:56 +0000 (16:09 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Thu, 11 Aug 2016 14:37:11 +0000 (10:37 -0400)
commitc45cc094d769c1c4621072febf1c8a088ae63068
tree569384084426450f160df435d0762ff628e4be05
parent29e3e11dbd02e25a95f977bc3a12c194c699421f
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 <csharp@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ [deleted file]
Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql [new file with mode: 0644]