From d9604850f60f10ee619e0e0bf1b5f08faf1f08a1 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Thu, 24 Apr 2014 20:58:17 -0400 Subject: [PATCH] Only create extension intarray if it does not already exist Simple change to skip over adding intarray if it already exists in a database for some reason. Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql index 4307f90987..a82802b859 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql @@ -2,7 +2,7 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('0864', :eg_version); -CREATE EXTENSION intarray; +CREATE EXTENSION IF NOT EXISTS intarray; -- while we have this opportunity, and before we start collecting -- CCVM IDs (below) carve out a nice space for stock ccvm values -- 2.43.2