test upgrade path (#1669)

montanalow · web-flow · commit 13e98ec90b37 · 2025-01-16T10:49:17.000-08:00
diff --git a/.github/workflows/ci.yml b/.github/workflows/ci.yml
@@ -55,6 +55,15 @@ jobs:
             cargo pgrx init
             echo "shared_preload_libraries = 'pgml'" >> ~/.pgrx/data-17/postgresql.conf
           fi
+      - name: Update extension test
+        if: steps.pgml_extension_changed.outputs.PGML_EXTENSION_CHANGED_FILES != '0'
+        run: |
+          git checkout origin/master
+          echo "\q" | cargo pgrx run
+          psql -p 28817 -h localhost -d pgml -P pager -c "DROP EXTENSION IF EXISTS pgml CASCADE; DROP SCHEMA IF EXISTS pgml CASCADE; CREATE EXTENSION pgml;"
+          git checkout $GITHUB_SHA
+          echo "\q" | cargo pgrx run
+          psql -p 28817 -h localhost -d pgml -P pager -c "ALTER EXTENSION pgml UPDATE;"
       - name: Unit tests
         if: steps.pgml_extension_changed.outputs.PGML_EXTENSION_CHANGED_FILES != '0'
         run: |
