metacat/src/upgrade-db-to-2.8.4-postgres.sql @ 10435
1 | 10349 | tao | /*
|
---|---|---|---|
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 | /*
|
||
8 | * update the database version
|
||
9 | */
|
||
10 | UPDATE db_version SET status=0; |
||
11 | |||
12 | INSERT INTO db_version (version, status, date_created) |
||
13 | VALUES ('2.8.4', 1, CURRENT_DATE); |