From bda47f5206d25303142e5ab90e0b09e2fbac5456 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sat, 8 Jan 2022 19:04:12 -0500 Subject: [PATCH] only create extension if not exists --- Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7.0-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7.0-upgrade-db.sql index 2e1fb9bfd4..46517120ae 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7.0-upgrade-db.sql @@ -402,7 +402,7 @@ ALTER TABLE actor.org_lasso ADD COLUMN global BOOL NOT NULL DEFAULT FALSE; -- check whether patch can be applied SELECT evergreen.upgrade_deps_block_check('1255', :eg_version); -CREATE EXTENSION earthdistance CASCADE; +CREATE EXTENSION IF NOT EXISTS earthdistance CASCADE; -- 005.schema.actors.sql -- 2.11.0