Hello.
I've upgraded my server from 7.0.6 to 7.2.0, it works OK (PostgreSQL 13), but then I've found in System information:
Database history tables use primary key No
I'm afraid it wasn't done earlier, when upgrading 5 to 6 or 6 to 7...
Is there a way to add primary keys to current 7.2 database? To which tables?
Docs mention 'history_upgrade_prepare.sql' script, but I do not have it within my installation.
Or at least give me a hint where can I find relevant installation sql scripts, to compare/recreate database structure manually.
I've upgraded my server from 7.0.6 to 7.2.0, it works OK (PostgreSQL 13), but then I've found in System information:
Database history tables use primary key No
I'm afraid it wasn't done earlier, when upgrading 5 to 6 or 6 to 7...
Is there a way to add primary keys to current 7.2 database? To which tables?
Docs mention 'history_upgrade_prepare.sql' script, but I do not have it within my installation.
Or at least give me a hint where can I find relevant installation sql scripts, to compare/recreate database structure manually.
Comment