[PostGIS] #5623: unpackaged upgrade from PostGIS 3.2 failing on ST_AsGeoJSON

[PostGIS]

#5623: unpackaged upgrade from PostGIS 3.2 failing on ST_AsGeoJSON
--------------------------+---------------------------
 Reporter:  robe          |      Owner:  strk
     Type:  defect        |     Status:  new
 Priority:  blocker       |  Milestone:  PostGIS 3.5.0
Component:  upgrade/hard  |    Version:  master
 Keywords:                |
--------------------------+---------------------------
 As a result of #5596 we are getting this regression on woodie.
 I can't replicate it locally, perhaps cause I am running PG16 and only
 have 3.3 and 3.4 installed or because I can't get the unpackaged path to
 kick in.

 {{{
 ALTER TABLE
 ALTER TABLE
 SELECT 8500
 DELETE 8500
 SET
 SET
 SET
 SET
 SET
  set_config
 ------------

 (1 row)

 SET
 SET
 SET
 SET
 ERROR:  function "st_asgeojson" already exists with same argument types
 -----------------------------------------------------------------------------
 make: ***
 [/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/regress/runtest.mk:24:
 check-regress] Error 3
 make: Leaving directory
 '/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/build/pg15/regress'
 FAIL: postgis script hard upgrade unpackaged3.2--:auto
 Cleaning up
 }}}

 This doesn't seem to affect extension upgrades.


 I see the new signature in postgis_restore_data.generated

 Does the old signature need to be put somewhere besides the
 postgis_drop_before.sql?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5623>
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.