[postgis-tickets] [PostGIS] #4639: Can't upgrade from 3.0.0alpha3 to 3.1.0dev (cannot drop function pgis_geometry_union_transfn)

[PostGIS]

#4639: Can't upgrade from 3.0.0alpha3 to 3.1.0dev (cannot drop function
pgis_geometry_union_transfn)
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.1.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:  upgrade
----------------------+---------------------------

Comment (by strk):

 This patch fixes the upgrade for me:
 {{{
 diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
 index 8d1c802bf..dd4f87a09 100644
 --- a/postgis/postgis.sql.in
 +++ b/postgis/postgis.sql.in
 @@ -3900,6 +3900,7 @@ CREATE OR REPLACE FUNCTION ST_Union (geometry[])
  -- we don't want to force drop of this agg since its often used in views
  -- parallel handling dealt with in postgis_after_upgrade.sql
  -- Changed: 2.5.0 use 'internal' stype
 +-- Changed: 3.0.0 step by pgis_geometry_union_transfn
  CREATE AGGREGATE ST_Union (geometry) (
         sfunc = pgis_geometry_accum_transfn,
         stype = internal,
 }}}

 Of course it forces a DROP/RESTORE of the aggregate for those who did NOT
 step to an alpha version, which is not ideal.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4639#comment:10>
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.