Mercurial > hg > orthanc-databases
changeset 741:9097dd8235b8 pg-next-699 tip
fix
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Mon, 22 Sep 2025 15:48:21 +0200 (11 hours ago) |
parents | 2382e6fab2b6 |
children | |
files | PostgreSQL/Plugins/SQL/PrepareIndex.sql |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql Mon Sep 22 11:02:20 2025 +0200 +++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql Mon Sep 22 15:48:21 2025 +0200 @@ -85,7 +85,6 @@ ); CREATE TABLE IF NOT EXISTS GlobalIntegers( - pk BIGSERIAL PRIMARY KEY, -- new in rev699 required for pg_repack to be able to reclaim space key INTEGER PRIMARY KEY, value BIGINT); -- GlobalIntegers keys: @@ -401,6 +400,7 @@ -- These changes will be applied at regular interval by an external thread or when someone -- requests the statistics CREATE TABLE IF NOT EXISTS GlobalIntegersChanges( + pk BIGSERIAL PRIMARY KEY, -- new in rev699 required for pg_repack to be able to reclaim space key INTEGER, value BIGINT);