From 082bb7963d7c7dec1c0f9859d2ff16dad2221eec Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Thu, 29 Mar 2012 10:15:30 -0400 Subject: [PATCH] Stamping No plperl Upgrade Script Signed-off-by: Thomas Berezansky --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.no_plperl.sql => 0696.no_plperl.sql} | 11 +++++++++++ 2 files changed, 12 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.no_plperl.sql => 0696.no_plperl.sql} (69%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 52dbf17c01..c2fc9a03ec 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0695', :eg_version); -- phasefx/tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0696', :eg_version); -- tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.no_plperl.sql b/Open-ILS/src/sql/Pg/upgrade/0696.no_plperl.sql similarity index 69% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.no_plperl.sql rename to Open-ILS/src/sql/Pg/upgrade/0696.no_plperl.sql index c2157db81f..38ba02898b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.no_plperl.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0696.no_plperl.sql @@ -1,3 +1,11 @@ +-- Evergreen DB patch 0696.no_plperl.sql +-- +-- FIXME: insert description of change, if needed +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0696', :eg_version); -- Re-create these as plperlu instead of plperl CREATE OR REPLACE FUNCTION auditor.set_audit_info(INT, INT) RETURNS VOID AS $$ @@ -14,4 +22,7 @@ CREATE OR REPLACE FUNCTION auditor.clear_audit_info() RETURNS VOID AS $$ delete($_SHARED{"eg_audit_ws"}); $$ LANGUAGE plperlu; +-- And remove the language so that we don't use it later. DROP LANGUAGE plperl; + +COMMIT; -- 2.43.2