From d8c27f7aa7714989de9c317b691273ad6ab944c7 Mon Sep 17 00:00:00 2001 From: James Fournie Date: Mon, 7 May 2012 11:08:06 -0700 Subject: [PATCH] We can't assume that 0526 was in fact run previously so we need to drop these more safely to avoid producing an error if 0526 wasn't run previously Signed-off-by: James Fournie Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql index c728c5ab69..4f8dff4ef7 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql @@ -6,9 +6,9 @@ -- DROP objects that might have existed from a prior run of 0526 -- Yes this is ironic. DROP TABLE IF EXISTS config.db_patch_dependencies; -ALTER TABLE config.upgrade_log DROP COLUMN applied_to; -DROP FUNCTION evergreen.upgrade_list_applied_deprecates(TEXT); -DROP FUNCTION evergreen.upgrade_list_applied_supersedes(TEXT); +ALTER TABLE config.upgrade_log DROP COLUMN IF EXISTS applied_to; +DROP FUNCTION IF EXISTS evergreen.upgrade_list_applied_deprecates(TEXT); +DROP FUNCTION IF EXISTS evergreen.upgrade_list_applied_supersedes(TEXT); BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('2.2-beta2'); -- 2.11.0