# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1739543801 -3600
# Node ID cfddeec356c509da249f199754ed7070af6800d6
# Parent  a66ad2d115fa3c6dd42a1ca45972e5bf21933fed
added version check

diff -r a66ad2d115fa -r cfddeec356c5 PostgreSQL/Plugins/SQL/Downgrades/Rev4ToRev3.sql
--- a/PostgreSQL/Plugins/SQL/Downgrades/Rev4ToRev3.sql	Fri Feb 14 13:25:40 2025 +0100
+++ b/PostgreSQL/Plugins/SQL/Downgrades/Rev4ToRev3.sql	Fri Feb 14 15:36:41 2025 +0100
@@ -1,6 +1,22 @@
 -- This file contains an SQL procedure to downgrade from schema Rev4 to Rev3 (version = 6).
   -- It re-installs the old childcount trigger mechanisms
 
+DO $$
+DECLARE
+    current_revision TEXT;
+    expected_revision TEXT;
+BEGIN
+    expected_revision := '4';
+
+    SELECT value INTO current_revision FROM GlobalProperties WHERE property = 4; -- GlobalProperty_DatabasePatchLevel
+
+    IF current_revision != expected_revision THEN
+        RAISE EXCEPTION 'Unexpected schema revision % to run this script.  Expected revision = %', current_revision, expected_revision;
+    END IF;
+END $$;
+
+---
+
 DROP TRIGGER IF EXISTS IncrementChildCount on Resources;
 DROP TRIGGER IF EXISTS DecrementChildCount on Resources;