1 --Upgrade Script for 3.3.0 to 3.3.1
2 \set eg_version '''3.3.1'''
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.3.1', :eg_version);
6 SELECT evergreen.upgrade_deps_block_check('1160', :eg_version);
8 INSERT INTO config.workstation_setting_type (name, grp, datatype, label)
10 'catalog.record.holds.prefetch', 'cat', 'bool',
12 'catalog.record.holds.prefetch',
13 'Pre-Fetch Record Holds',
18 SELECT evergreen.upgrade_deps_block_check('1162', :eg_version);
20 INSERT INTO config.workstation_setting_type (name, grp, datatype, label)
22 'eg.print.config.default', 'gui', 'object',
24 'eg.print.config.default',
25 'Print config for default context',
29 'eg.print.config.receipt', 'gui', 'object',
31 'eg.print.config.receipt',
32 'Print config for receipt context',
36 'eg.print.config.label', 'gui', 'object',
38 'eg.print.config.label',
39 'Print config for label context',
43 'eg.print.config.mail', 'gui', 'object',
45 'eg.print.config.mail',
46 'Print config for mail context',
50 'eg.print.config.offline', 'gui', 'object',
52 'eg.print.config.offline',
53 'Print config for offline context',
59 SELECT evergreen.upgrade_deps_block_check('1163', :eg_version); -- JBoyer/Dyrcona/bshum/JBoyer
61 CREATE OR REPLACE FUNCTION vandelay.flatten_marc_hstore(
63 ) RETURNS HSTORE AS $func$
67 ARRAY_AGG(tag || (COALESCE(subfield, ''))),
71 SELECT tag, subfield, ARRAY_AGG(value)::TEXT AS value
74 CASE WHEN tag = '020' THEN -- caseless -- isbn
75 LOWER((SELECT REGEXP_MATCHES(value,$$^(\S{10,17})$$))[1] || '%')
76 WHEN tag = '022' THEN -- caseless -- issn
77 LOWER((SELECT REGEXP_MATCHES(value,$$^(\S{4}[- ]?\S{4})$$))[1] || '%')
78 WHEN tag = '024' THEN -- caseless -- upc (other)
83 FROM vandelay.flatten_marc(record_xml)) x
84 GROUP BY tag, subfield ORDER BY tag, subfield
88 $func$ LANGUAGE PLPGSQL;
92 -- No transaction needed. This can be run on a live, production server.
93 SELECT evergreen.upgrade_deps_block_check('1161', :eg_version); -- jboyer/stompro/gmcharlt
95 CREATE INDEX CONCURRENTLY atev_template_output ON action_trigger.event (template_output);
96 CREATE INDEX CONCURRENTLY atev_async_output ON action_trigger.event (async_output);
97 CREATE INDEX CONCURRENTLY atev_error_output ON action_trigger.event (error_output);