search

indico / indico-migrate

Utility to migrate Indico 1.2 ZODB databases to 2.0 (Postgres)
GNU General Public License v3.0
2 stars 3 forks source link

Event ID sequence is not synced after migration #12

Closed ThiefMaster closed 7 years ago

ThiefMaster commented 7 years ago

Should be fixed in the migration script.

SQL command to fix it in an already-migrated DB:

SELECT setval(pg_get_serial_sequence('events.events', 'id'), (SELECT max(id) FROM events.events));
ThiefMaster commented 7 years ago

Room booking sequences may also need fixing.