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, main has been updated via aee5289e4334e678cc9649aa0cb51eecc9a51641 (commit) from 988a668f3342e7e1fa9573e40cd17feb9bb4a286 (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 aee5289e4334e678cc9649aa0cb51eecc9a51641 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