3 SELECT evergreen.upgrade_deps_block_check('0710', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.could_be_serial_holding_code(TEXT) RETURNS BOOL AS $$
10 my $holding_code = (new JSON::XS)->decode(shift);
11 new MARC::Field('999', @$holding_code);
16 -- This throws away data, but only data that causes breakage anyway.
17 UPDATE serial.issuance
18 SET holding_code = NULL
19 WHERE NOT could_be_serial_holding_code(holding_code);
21 ALTER TABLE serial.issuance
22 DROP CONSTRAINT IF EXISTS issuance_holding_code_check;
24 ALTER TABLE serial.issuance
25 ADD CHECK (holding_code IS NULL OR could_be_serial_holding_code(holding_code));