[postgis-tickets] r16333 - Fix sfcgal upgrade in run_test.pl

[Sandro Santilli]

Author: strk
Date: 2018-01-18 13:41:32 -0800 (Thu, 18 Jan 2018)
New Revision: 16333

Modified:
   trunk/regress/run_test.pl
Log:
Fix sfcgal upgrade in run_test.pl

Modified: trunk/regress/run_test.pl
===================================================================
--- trunk/regress/run_test.pl	2018-01-18 19:31:53 UTC (rev 16332)
+++ trunk/regress/run_test.pl	2018-01-18 21:41:32 UTC (rev 16333)
@@ -1475,15 +1475,16 @@
 
     if ( $OPT_WITH_SFCGAL )
     {
+			my $sql;
 			if ( semver_lessthan($OPT_UPGRADE_FROM, "2.2.0") )
 			{
 				print "NOTICE: installing SFCGAL extension on upgrade "
 						. "as it was not available in version $OPT_UPGRADE_FROM\n";
-				my $sql = "CREATE EXTENSION postgis_sfcgal VERSION '${nextver}'";
+				$sql = "CREATE EXTENSION postgis_sfcgal VERSION '${nextver}'";
 			}
 			else
 			{
-				my $sql = "ALTER EXTENSION postgis_sfcgal UPDATE TO '${nextver}'";
+				$sql = "ALTER EXTENSION postgis_sfcgal UPDATE TO '${nextver}'";
 			}
       $cmd = "psql $psql_opts -c \"" . $sql . "\" $DB >> $REGRESS_LOG 2>&1";
       $rv = system($cmd);