[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
 Keywords:           |
---------------------+---------------------------
 I just noticed GHA has been failing for a couple of runs, but it's random.

 So guessing it has to do with parallel jobs?


 https://github.com/postgis/postgis/actions/runs/10935290396/job/30356784011

 Errors like
 {{{
 _postgis_drop_function_by_signature
 -------------------------------------

 (1 row)

 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis_upgrade.sql:843: ERROR:  syntax
 error at or near "DECLARE"
 LINE 122: DECLARE
 }}}

 and


 {{{

 (1 row)

 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis_upgrade.sql:4433: ERROR:  syntax
 error at or near "CREATE"
 LINE 39: CREATE OR REPLACE FUNCTION _postgis_drop_function_by_identit...
          ^
 CONTEXT:  invalid type name "CREATE OR REPLACE FUNCTION
 _postgis_drop_function_by_identity(
         function_name text,
         function_arguments text,
         deprecated_in_version text "
 }}}

 I know strk had completed some changes recently for parallelism, which is
 around the time these failures started happening.

 The bots failing is random.  It's not all but across various PG versions,
 GEOS versions, and GDAL versions
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5780>
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.