[postgis-tickets] [PostGIS] #5287: PostGIS 2.5 error on upgrade view test

[PostGIS]

#5287: PostGIS 2.5 error on upgrade view test
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  blocker                |  Milestone:  PostGIS 2.5.9
Component:  build/upgrade/install  |    Version:  2.5.x
 Keywords:                         |
-----------------------------------+---------------------------
 I think this might be recent because of addition of data upgrade tests

 This is on debbie
 {{{
 GEOS config:          /var/lib/jenkins/workspace/geos/rel-3.8w64/bin/geos-
 config
 10:42:11   GEOS version:         3.8.4dev
 10:42:11   GDAL config:
 /var/lib/jenkins/workspace/gdal/rel-3.4w64/bin/gdal-config
 10:42:11   GDAL version:         3.4.3
 10:42:11   SFCGAL config:        /usr/bin/sfcgal-config
 10:42:11   SFCGAL version:       1.3.8
 10:42:11   PostgreSQL config:
 /var/lib/jenkins/workspace/pg/rel/pg12w64/bin/pg_config
 10:42:11   PostgreSQL version:   PostgreSQL 12.13
 10:42:11   PROJ4 version:        72
 10:46:40
 psql:/var/lib/jenkins/workspace/postgis/branches/2.5/regress/../regress/00
 -regress-install/share/contrib/postgis/postgis_upgrade.sql:80: NOTICE:
 function st_curvetoline(geometry) does not exist, skipping
 10:46:40        postgis_major_version_check
 10:46:40 ------------------------------------------
 10:46:40  Scripts versions checked for upgrade: ok
 10:46:40 (1 row)
 10:46:40
 10:46:40
 psql:/var/lib/jenkins/workspace/postgis/branches/2.5/regress/../regress/00
 -regress-install/share/contrib/postgis/postgis_upgrade.sql:3243: ERROR:
 cannot drop function st_union(geometry) because other objects depend on it
 10:46:40 DETAIL:  view upgrade_view_test depends on function
 st_union(geometry)
 10:46:40 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 10:46:40 CONTEXT:  SQL statement "DROP AGGREGATE IF EXISTS ST_Union
 (geometry)"
 10:46:40 PL/pgSQL function inline_code_block line 7 at EXECUTE
 10:46:40
 ----------------------------------------------------------------------------
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5287>
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.