Open-ILS/src/sql/Pg/upgrade/0716.coded_value_map_id_seq_fix.sql

   1 -- Evergreen DB patch 0716.coded_value_map_id_seq_fix.sql
   2 BEGIN;
   3
   4 -- check whether patch can be applied
   5 SELECT evergreen.upgrade_deps_block_check('0716', :eg_version);
   6
   7 SELECT SETVAL('config.coded_value_map_id_seq'::TEXT, (SELECT max(id) FROM config.coded_value_map));
   8
   9 COMMIT;