This is an automated email from the git hooks/post-receive script. It was generated because a ref change was pushed to the repository containing the project "Evergreen ILS". The branch, rel_3_14 has been updated via b364ba7de62d6d0ad562ff6a07c74170b62a937b (commit) from d8570bedab29ceb0afc67295472b3ad064a266ab (commit) Those revisions listed above that are new to this repository have not appeared on any other notification email; so we list those revisions in full, below. - Log ----------------------------------------------------------------- commit b364ba7de62d6d0ad562ff6a07c74170b62a937b Author: Jane Sandberg <js7389@princeton.edu> Date: Wed Jun 18 14:40:41 2025 -0700 Forward-port 3.14.7 upgrade script Signed-off-by: Jane Sandberg <js7389@princeton.edu> diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.14.6-3.14.7-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.14.6-3.14.7-upgrade-db.sql new file mode 100644 index 0000000000..06bdd9802b --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.14.6-3.14.7-upgrade-db.sql @@ -0,0 +1,26 @@ +--Upgrade Script for 3.14.6 to 3.14.7 +\set eg_version '''3.14.7''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.14.7', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1471', :eg_version); + +CREATE OR REPLACE FUNCTION evergreen.oils_xpath_string(text, text, text, anyarray) RETURNS text +AS $F$ + SELECT ARRAY_TO_STRING( + oils_xpath( + $1 || + CASE WHEN $1 ~ $re$/[^/[]*@[^]]+$$re$ OR $1 ~ $re$\)$$re$ THEN '' ELSE '//text()' END, + $2, + $4 + ), + $3 + ); +$F$ LANGUAGE SQL IMMUTABLE; + + +COMMIT; + +-- Update auditor tables to catch changes to source tables. +-- Can be removed/skipped if there were no schema changes. +SELECT auditor.update_auditors(); ----------------------------------------------------------------------- Summary of changes: .../3.14.6-3.14.7-upgrade-db.sql} | 7 +++++++ 1 file changed, 7 insertions(+) copy Open-ILS/src/sql/Pg/{upgrade/1471.function.oils_xpath_string.sql => version-upgrade/3.14.6-3.14.7-upgrade-db.sql} (62%) hooks/post-receive -- Evergreen ILS