[PostGIS] #5780: Random errors on GHA postgis install some sort of incomplete scripts

[PostGIS]

#5780: Random errors on GHA postgis install some sort of incomplete scripts
----------------------+---------------------------
  Reporter:  robe     |      Owner:  strk
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.5.0
 Component:  install  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Just a note about the commonality of these, they all involve random syntax
 errors in raster scripts primarily the rtpostgis_upgrade.sql script

 and here is another pattern of failure not with sql script errors


 {{{
 #strip BEGIN/COMMIT since these are not allowed in extensions
 make[3]: Leaving directory '/src/postgis/raster/rt_pg'
 make[3]: *** [Makefile:156: rtpostgis_upgrade.sql.in] Error 255
 make[3]: *** Deleting file 'rtpostgis_upgrade.sql.in'
 make[3]: *** Waiting for unfinished jobs....
 make[2]: *** [Makefile:76:
 ../../raster/rt_pg/rtpostgis_upgrade_cleanup.sql] Error 2
 make[2]: *** Deleting file
 '../../raster/rt_pg/rtpostgis_upgrade_cleanup.sql'
 make[3]: *** [Makefile:156: rtpostgis_upgrade.sql.in] Error 255
 make[2]: *** Waiting for unfinished jobs....
 make[3]: *** Waiting for unfinished jobs....
 # WARNING: we should make sure these are not internal to function bodies
 cat ../../postgis/common_before_upgrade.sql
 ../../postgis/postgis_before_upgrade.sql
 sql/postgis_upgrade_for_extension.sql.in
 ../../postgis/postgis_after_upgrade.sql
 ../../postgis/common_after_upgrade.sql | /usr/bin/perl -pe 's/BEGIN\;//g ;
 s/COMMIT\;//g' > sql/postgis_upgrade_for_extension.sql
 make[2]: *** [Makefile:76: ../../raster/rt_pg/uninstall_rtpostgis.sql]
 Error 2
 make[3]: Leaving directory '/src/postgis/raster/rt_pg'
 make[2]: *** Deleting file '../../raster/rt_pg/uninstall_rtpostgis.sql'
 make[3]: Leaving directory '/src/postgis/raster/rt_pg'
 make[2]: *** [Makefile:76: ../../raster/rt_pg/rtpostgis_drop.sql] Error 2
 make[2]: Leaving directory '/src/postgis/extensions/postgis'
 make[2]: *** Deleting file '../../raster/rt_pg/rtpostgis_drop.sql'
 make[1]: *** [Makefile:36: all] Error 1
 make[1]: Leaving directory '/src/postgis/extensions'
 make: *** [GNUmakefile:34: all] Error 1
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5780#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.