From 4196ef8f61062f37b8b0b47657ea581bbfe6990d Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Wed, 21 Mar 2012 09:55:31 -0400 Subject: [PATCH] Fix Auditor Boost upgrade script CREATE FUNCTION needs an OR REPLACE included. Signed-off-by: Thomas Berezansky Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/0686.schema.auditor_boost.sql | 2 +- Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0686.schema.auditor_boost.sql b/Open-ILS/src/sql/Pg/upgrade/0686.schema.auditor_boost.sql index 9ec8145f4f..74f768f3e3 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0686.schema.auditor_boost.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0686.schema.auditor_boost.sql @@ -29,7 +29,7 @@ CREATE OR REPLACE FUNCTION auditor.clear_audit_info() RETURNS VOID AS $$ delete($_SHARED{"eg_audit_ws"}); $$ LANGUAGE plperl; -CREATE FUNCTION auditor.create_auditor_history ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $creator$ +CREATE OR REPLACE FUNCTION auditor.create_auditor_history ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $creator$ BEGIN EXECUTE $$ CREATE TABLE auditor.$$ || sch || $$_$$ || tbl || $$_history ( 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 95d46ed8a5..b59bcc0fac 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 @@ -13475,7 +13475,7 @@ CREATE OR REPLACE FUNCTION auditor.clear_audit_info() RETURNS VOID AS $$ delete($_SHARED{"eg_audit_ws"}); $$ LANGUAGE plperl; -CREATE FUNCTION auditor.create_auditor_history ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $creator$ +CREATE OR REPLACE FUNCTION auditor.create_auditor_history ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $creator$ BEGIN EXECUTE $$ CREATE TABLE auditor.$$ || sch || $$_$$ || tbl || $$_history ( -- 2.11.0