3 SELECT evergreen.upgrade_deps_block_check('1039', :eg_version); -- jeffdavis/gmcharlt
5 UPDATE config.org_unit_setting_type
6 SET datatype = 'link', fm_class = 'vms'
7 WHERE name = 'vandelay.default_match_set'
8 AND datatype = 'string'
11 \echo Existing vandelay.default_match_set that do not
12 \echo correspond to match sets
13 SELECT aou.shortname, aous.value
14 FROM actor.org_unit_setting aous
15 JOIN actor.org_unit aou ON (aou.id = aous.org_unit)
16 WHERE aous.name = 'vandelay.default_match_set'
20 oils_json_to_text(aous.value)::INT NOT IN (
21 SELECT id FROM vandelay.match_set
25 \echo And now deleting the bad values, as otherwise they
26 \echo will break the Library Settings Editor.
28 FROM actor.org_unit_setting aous
29 WHERE aous.name = 'vandelay.default_match_set'
33 oils_json_to_text(aous.value)::INT NOT IN (
34 SELECT id FROM vandelay.match_set