From 501f26fe7f0da1d4a5d6962b2c3a820eec3ccc4d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 31 May 2011 12:16:16 -0400 Subject: [PATCH] Repaired typo on schema and upgrade SQL ARRAY_ACUM is not a defined function. Per Dan Scott, replaced with ARRAY_AGG instead of the correctly spelled ARRAY_ACCUM, since we'll be using that function in place of ARRAY_ACCUM going forward. Thanks, Dan. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 4 ++-- Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ebb1cf1343..822623b927 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -876,8 +876,8 @@ Upgrade script % can not be applied: deprecated by % superseded by %', my_db_patch, - ARRAY_ACUM(evergreen.upgrade_list_applied_deprecates(my_db_patch)), - ARRAY_ACUM(evergreen.upgrade_list_applied_supersedes(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_deprecates(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_supersedes(my_db_patch)), evergreen.upgrade_list_applied_deprecated(my_db_patch), evergreen.upgrade_list_applied_superseded(my_db_patch); END IF; diff --git a/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql b/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql index e70705367d..42de0788d2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql @@ -86,8 +86,8 @@ Upgrade script % can not be applied: deprecated by % superseded by %', my_db_patch, - ARRAY_ACUM(evergreen.upgrade_list_applied_deprecates(my_db_patch)), - ARRAY_ACUM(evergreen.upgrade_list_applied_supersedes(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_deprecates(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_supersedes(my_db_patch)), evergreen.upgrade_list_applied_deprecated(my_db_patch), evergreen.upgrade_list_applied_superseded(my_db_patch); END IF; -- 2.11.0