metacat/src/upgrade-db-to-2.8.2-postgres.sql @ 10311
| 1 | 10302 | 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.2', 1, CURRENT_DATE); |