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);