3 SELECT evergreen.upgrade_deps_block_check('1188', :eg_version);
5 UPDATE action.circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL;
7 UPDATE action.aged_circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL;
11 -- The following two changes cannot occur in a transaction with the
12 -- above updates because we will get an error about not being able to
13 -- alter a table with pending transactions. They also need to occur
14 -- after the above updates or the SET NOT NULL change will fail.
16 ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE;
17 ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET NOT NULL;
19 ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE;
20 ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET NOT NULL;