projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: befdd0b) | patch
LP1287967 - drop reporter.classic_current_circ view as part of 0864 upgrade
authorBen Shum <bshum@biblio.org>
Thu, 6 Mar 2014 22:46:30 +0000 (17:46 -0500)
committerBen Shum <bshum@biblio.org>
Sun, 16 Mar 2014 19:29:19 +0000 (15:29 -0400)
commit356b8262679babe942fcea96c9e628058fc48c9b
treec8130f1131a11d54ba22c684a1800382a24fbdb3tree
parentbefdd0b7c9703ff94ee3f3f74aae4d1fd42e4469commit | diff
LP1287967 - drop reporter.classic_current_circ view as part of 0864 upgrade

As noted in the bug description, attempts to run 0864.MVF_CRA-upgrade.sql will
fail on a database where the reporter.classic_current_circ view is present.

Add a DROP VIEW IF EXISTS and then include a note that administrators will need
to recreate the VIEW afterwards if desired.

Signed-off-by: Ben Shum <bshum@biblio.org>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql diff | blob | history
Evergreen working repo (PINES)