1 --Upgrade Script for 2.6.0 to 2.6.1
2 \set eg_version '''2.6.1'''
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.6.1', :eg_version);
6 SELECT evergreen.upgrade_deps_block_check('0880', :eg_version);
8 CREATE OR REPLACE FUNCTION authority.calculate_authority_linking(
9 rec_id BIGINT, rec_control_set INT, rec_marc_xml XML
10 ) RETURNS SETOF authority.authority_linking AS $func$
12 acsaf authority.control_set_authority_field%ROWTYPE;
14 aal authority.authority_linking%ROWTYPE;
16 IF rec_control_set IS NULL THEN
17 -- No control_set on record? Guess at one
18 SELECT control_set INTO rec_control_set
19 FROM authority.control_set_authority_field
22 XPATH('//*[starts-with(@tag,"1")]/@tag',rec_marc_xml)::TEXT[]
27 RAISE WARNING 'Could not even guess at control set for authority record %', rec_id;
35 SELECT * FROM authority.control_set_authority_field
36 WHERE control_set = rec_control_set
37 AND linking_subfield IS NOT NULL
38 AND main_entry IS NOT NULL
40 -- Loop over the trailing-number contents of all linking subfields
42 SELECT SUBSTRING( x::TEXT, '\d+$' )
48 || acsaf.linking_subfield
55 -- Ignore links that are null, malformed, circular, or point to
56 -- non-existent authority records.
57 IF link IS NOT NULL AND link::BIGINT <> rec_id THEN
58 PERFORM * FROM authority.record_entry WHERE id = link::BIGINT;
60 aal.target := link::BIGINT;
61 aal.field := acsaf.id;
68 $func$ LANGUAGE PLPGSQL;
72 SELECT evergreen.upgrade_deps_block_check('0881', :eg_version);
74 UPDATE config.org_unit_setting_type
75 SET description = replace(replace(description,'Original','Physical'),'"ol"','"physical_loc"')
76 WHERE name = 'opac.org_unit_hiding.depth';