Project

General

Profile

metacat / src / upgrade-db-to-2.8.0-postgres.sql @ 9794

1
/*
2
 * Ensure xml_catalog sequence is at table max
3
 */
4
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));
5

    
6
/*
7
 * update the database version
8
 */
9
UPDATE db_version SET status=0;
10

    
11
INSERT INTO db_version (version, status, date_created) 
12
  VALUES ('2.8.0', 1, CURRENT_DATE);