metacat/src/upgrade-db-to-2.9.0-postgres.sql @ 10447
1 | 10209 | 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 | * 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.9.0', 1, CURRENT_DATE); |