[postgis-tickets] r16237 - Upgrade SFCGAL too when requested

[Sandro Santilli]

Author: strk
Date: 2018-01-09 10:06:42 -0800 (Tue, 09 Jan 2018)
New Revision: 16237

Modified:
   trunk/regress/run_test.pl
Log:
Upgrade SFCGAL too when requested

Might help with https://debbie.postgis.net/job/PostGIS_Regress/8247/console

Modified: trunk/regress/run_test.pl
===================================================================
--- trunk/regress/run_test.pl	2018-01-09 17:51:22 UTC (rev 16236)
+++ trunk/regress/run_test.pl	2018-01-09 18:06:42 UTC (rev 16237)
@@ -1401,6 +1401,22 @@
             die "$script not found\n";
         }
     }
+
+    if ( $OPT_WITH_SFCGAL )
+    {
+        my $script = `ls ${STAGED_SCRIPTS_DIR}/sfcgal_upgrade.sql`;
+        chomp($script);
+        if ( -e $script )
+        {
+            print "Upgrading sfcgal\n";
+            load_sql_file($script);
+        }
+        else
+        {
+            die "$script not found\n";
+        }
+    }
+
     return 1;
 }
 
@@ -1437,6 +1453,17 @@
       }
     }
 
+    if ( $OPT_WITH_SFCGAL )
+    {
+      my $sql = "ALTER EXTENSION postgis_sfcgal UPDATE TO '${nextver}'";
+      $cmd = "psql $psql_opts -c \"" . $sql . "\" $DB >> $REGRESS_LOG 2>&1";
+      $rv = system($cmd);
+      if ( $rv ) {
+        fail "Error encountered creating EXTENSION POSTGIS_SFCGAL", $REGRESS_LOG;
+        die;
+      }
+    }
+
     return 1;
 }