Mercurial > hg > orthanc-databases

diff PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 448:f2427f94d879 pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added downgrade script + renames version
author Alain Mazy <am@osimis.io>
date Wed, 17 Jan 2024 16:22:08 +0100
parents d979f25e60cf
children c437ec7be2b0
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Mon Jan 15 18:27:20 2024 +0100
+++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp	Wed Jan 17 16:22:08 2024 +0100
@@ -66,7 +66,7 @@
     std::string query;
 
     Orthanc::EmbeddedResources::GetFileResource
-      (query, Orthanc::EmbeddedResources::POSTGRESQL_PREPARE_INDEX_V2);
+      (query, Orthanc::EmbeddedResources::POSTGRESQL_PREPARE_INDEX);
     t.GetDatabaseTransaction().ExecuteMultiLines(query);
 
     SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabaseSchemaVersion, 6);
@@ -194,7 +194,7 @@
             std::string query;
 
             Orthanc::EmbeddedResources::GetFileResource
-              (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_V1);
+              (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_V6_1);
             t.GetDatabaseTransaction().ExecuteMultiLines(query);
           }
           
@@ -205,7 +205,7 @@
             std::string query;
 
             Orthanc::EmbeddedResources::GetFileResource
-              (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_V1_TO_V2);
+              (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_V6_1_TO_V6_2);
             t.GetDatabaseTransaction().ExecuteMultiLines(query);
 
             // apply all idempotent changes that are in the PrepareIndexV2