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_15 has been updated via d38f7262a47bbbbb5ce08f94b999c15168281356 (commit) from d9054513e29ac534e1e4f3a6fae1e5e42cf24394 (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 d38f7262a47bbbbb5ce08f94b999c15168281356 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