# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1790156031 -7200
# Node ID e6580e4c3b4e1a5441bbc1149e439667d2f076e6
# Parent  3448d318635c84a3c8fa50a41566f79e9cd44fcd
fix psql downgrade tests

diff -r 3448d318635c -r e6580e4c3b4e NewTests/PostgresUpgrades/downgrade.sh
--- a/NewTests/PostgresUpgrades/downgrade.sh	Tue Sep 22 15:09:04 2026 +0200
+++ b/NewTests/PostgresUpgrades/downgrade.sh	Wed Sep 23 11:33:51 2026 +0200
@@ -1,4 +1,6 @@
 #!/bin/bash
+set -e
+set -x
 
 pushd /scripts
 
@@ -17,9 +19,11 @@
 
 wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev11ToRev10.sql --output-document /tmp/downgrade.sql
 
-psql -U postgres -f /tmp/downgrade.sql
-
+psql -v ON_ERROR_STOP=1 -U postgres -f /tmp/downgrade.sql
+if [ $? -ne 0 ]; then
+    echo "psql failed!"
+    exit 1
+fi
 # if you want to test a downgrade procedure, you may use this code ...
 # psql -U postgres -f downgrade.sql
 popd
-popd