# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1755072566 -7200
# Node ID ae6dabec9af706254dbc74dadf9e593fe1dcbd81
# Parent  9f41a8c94f9c45b74390e717ffdf301f60f25420
PG 9.0

diff -r 9f41a8c94f9c -r ae6dabec9af7 PostgreSQL/CMakeLists.txt
--- a/PostgreSQL/CMakeLists.txt	Wed Aug 13 09:57:38 2025 +0200
+++ b/PostgreSQL/CMakeLists.txt	Wed Aug 13 10:09:26 2025 +0200
@@ -22,14 +22,14 @@
 cmake_minimum_required(VERSION 2.8...4.0)
 project(OrthancPostgreSQL)
 
-set(ORTHANC_PLUGIN_VERSION "mainline")
+set(ORTHANC_PLUGIN_VERSION "9.0")
 
 # This is the preferred version of the Orthanc SDK for this plugin
-set(ORTHANC_SDK_DEFAULT_VERSION "1.12.8")
+set(ORTHANC_SDK_DEFAULT_VERSION "1.12.9")
 
 # This is the list of the versions of the Orthanc SDK against which
 # this plugin will compile
-set(ORTHANC_SDK_COMPATIBLE_VERSIONS "1.12.3" "1.12.4" "1.12.5" "1.12.8")
+set(ORTHANC_SDK_COMPATIBLE_VERSIONS "1.12.3" "1.12.4" "1.12.5" "1.12.8" "1.12.9")
 
 # This is the minimal version of the Orthanc runtime that will provide
 # best performance. If the version of the Orthanc runtime is below
@@ -37,13 +37,13 @@
 # plugin will still start).
 set(ORTHANC_OPTIMAL_VERSION_MAJOR    1)
 set(ORTHANC_OPTIMAL_VERSION_MINOR    12)
-set(ORTHANC_OPTIMAL_VERSION_REVISION 5)
+set(ORTHANC_OPTIMAL_VERSION_REVISION 9)
 
 if (ORTHANC_PLUGIN_VERSION STREQUAL "mainline")
   set(ORTHANC_FRAMEWORK_VERSION "mainline")
   set(ORTHANC_FRAMEWORK_DEFAULT_SOURCE "hg")
 else()
-  set(ORTHANC_FRAMEWORK_VERSION "1.12.8")
+  set(ORTHANC_FRAMEWORK_VERSION "1.12.9")
   set(ORTHANC_FRAMEWORK_DEFAULT_SOURCE "web")
 endif()
 
diff -r 9f41a8c94f9c -r ae6dabec9af7 PostgreSQL/NEWS
--- a/PostgreSQL/NEWS	Wed Aug 13 09:57:38 2025 +0200
+++ b/PostgreSQL/NEWS	Wed Aug 13 10:09:26 2025 +0200
@@ -1,11 +1,11 @@
-Pending changes in the mainline
-===============================
+Release 9.0 (2025-08-13)
+========================
 
-DB schema revision: 5
+DB schema revision: 6
 Minimum plugin SDK (for build): 1.12.5
-Optimal plugin SDK (for build): 1.12.5
+Optimal plugin SDK (for build): 1.12.9
 Minimum Orthanc runtime: 1.12.5
-Optimal Orthanc runtime: 1.12.6
+Optimal Orthanc runtime: 1.12.9
 
 Minimal Postgresql Server version: 9
 Optimal Postgresql Server version: 11+
@@ -21,8 +21,8 @@
 * New metrics "orthanc_index_active_connections" showing the current number
   of active connections.
 * Added support for AuditLogs.  The PostgreSQL plugin is listening to audit logs
-  and is storing them in the SQL Database.
-  They can be browsed through the API route /plugins/postgresql/audit-logs
+  that other plugins can emit and is storing them in the SQL Database.
+  They can be browsed through the API route /plugins/postgresql/audit-logs?user-id=x&since=1&limit=100&log-data-format=json&from-timestamp=2025-08-11T11:25:55.639Z&to-timestamp=2025-08-11T14:25:55.639Z&resource-id=y&action=z
 
 Maintenance:
 * Optimized the CreateInstance SQL query.