[postgis-tickets] [PostGIS] #4523: Upgrade 2.1.9 to 3.0.0rc1 - can not drop function st_union(geometry) because other objects depend on it

[PostGIS]

#4523: Upgrade 2.1.9 to 3.0.0rc1 - can not drop function st_union(geometry)
because other objects depend on it
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.0.0
 Component:  build/upgrade/install  |    Version:  trunk
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by strk):

 It doesn't look like it changed earlier:
 {{{
 $ grep -A6 'AGGREGATE ST_Union' postgis*/postgis/postgis.sql.in
 postgis-1.5/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (
 postgis-1.5/postgis/postgis.sql.in-     basetype = geometry,
 postgis-1.5/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-1.5/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-1.5/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-1.5/postgis/postgis.sql.in-     );
 postgis-1.5/postgis/postgis.sql.in-
 --
 postgis-2.0/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (
 postgis-2.0/postgis/postgis.sql.in-     basetype = geometry,
 postgis-2.0/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.0/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-2.0/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.0/postgis/postgis.sql.in-     );
 postgis-2.0/postgis/postgis.sql.in-
 --
 postgis-2.1/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (
 postgis-2.1/postgis/postgis.sql.in-     basetype = geometry,
 postgis-2.1/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.1/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-2.1/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.1/postgis/postgis.sql.in-     );
 postgis-2.1/postgis/postgis.sql.in-
 --
 postgis-2.2/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (
 postgis-2.2/postgis/postgis.sql.in-     basetype = geometry,
 postgis-2.2/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.2/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-2.2/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.2/postgis/postgis.sql.in-     );
 postgis-2.2/postgis/postgis.sql.in-
 --
 postgis-2.3/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (
 postgis-2.3/postgis/postgis.sql.in-     basetype = geometry,
 postgis-2.3/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.3/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-2.3/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.3/postgis/postgis.sql.in-     );
 postgis-2.3/postgis/postgis.sql.in-
 --
 postgis-2.4/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (geometry) (
 postgis-2.4/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.4/postgis/postgis.sql.in-     stype = pgis_abs,
 postgis-2.4/postgis/postgis.sql.in-#if POSTGIS_PGSQL_VERSION >= 96
 postgis-2.4/postgis/postgis.sql.in-     parallel = safe,
 postgis-2.4/postgis/postgis.sql.in-#endif
 postgis-2.4/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.4/postgis/postgis.sql.in-     );
 --
 postgis-2.5/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (geometry) (
 postgis-2.5/postgis/postgis.sql.in-     sfunc =
 pgis_geometry_accum_transfn,
 postgis-2.5/postgis/postgis.sql.in-     stype = internal,
 postgis-2.5/postgis/postgis.sql.in-#if POSTGIS_PGSQL_VERSION >= 96
 postgis-2.5/postgis/postgis.sql.in-     parallel = safe,
 postgis-2.5/postgis/postgis.sql.in-#endif
 postgis-2.5/postgis/postgis.sql.in-     finalfunc =
 pgis_geometry_union_finalfn
 postgis-2.5/postgis/postgis.sql.in-     );
 --
 postgis/postgis/postgis.sql.in:CREATE AGGREGATE ST_Union (geometry) (
 postgis/postgis/postgis.sql.in- sfunc = pgis_geometry_accum_transfn,
 postgis/postgis/postgis.sql.in- stype = internal,
 postgis/postgis/postgis.sql.in-#if POSTGIS_PGSQL_VERSION >= 96
 postgis/postgis/postgis.sql.in- parallel = safe,
 postgis/postgis/postgis.sql.in-#endif
 postgis/postgis/postgis.sql.in- finalfunc = pgis_geometry_union_finalfn
 postgis/postgis/postgis.sql.in- );
 }}}

 So.. maybe Paul just forgot to remove the {{{DROP AGGREGATE}}} line from
 upgrade_before ?

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