[PostGIS] #5650: debbie showing failure on upgrade - ERROR: cannot drop operator @(geometry, geometry) because other objects depend on it (enforce_max_extent_rast_

[PostGIS]

#5650: debbie showing failure on upgrade - ERROR:  cannot drop operator
@(geometry,geometry) because other objects depend on it
(enforce_max_extent_rast_
---------------------+---------------------------
 Reporter:  robe     |      Owner:  robe
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.4.2
Component:  raster   |    Version:  3.4.x
 Keywords:           |
---------------------+---------------------------
 Seems to be failing on rast constraint and ST_Envelope(raster)
 {{{
 04:49:03 psql:/var/lib/jenkins/workspace/postgis/branches/3.5/regress/00
 -regress-install/share/contrib/postgis/uninstall_topology.sql:330: NOTICE:
 New search_path: "$user", public
 04:49:03                  stripfromsearchpath
 04:49:03 ------------------------------------------------------
 04:49:03  topology has been stripped off database search_path
 04:49:03 (1 row)
 04:49:03
 04:49:03 psql:/var/lib/jenkins/workspace/postgis/branches/3.5/regress/00
 -regress-install/share/contrib/postgis/uninstall_topology.sql:332: NOTICE:
 drop cascades to function undef_helper.stripfromsearchpath(character
 varying)
 04:49:03 NOTICE:  schema "public" already exists, skipping
 04:49:03 psql:/var/lib/jenkins/workspace/postgis/branches/3.5/regress/00
 -regress-install/share/contrib/postgis/uninstall_rtpostgis.sql:70: ERROR:
 cannot drop function st_envelope(raster) because other objects depend on
 it
 04:49:03 DETAIL:  constraint enforce_max_extent_rast on table loadedrast
 depends on function st_envelope(raster)
 04:49:03 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 04:49:03 NOTICE:  schema "public" already exists, skipping
 04:49:03 NOTICE:  schema "public" already exists, skipping
 04:49:03 psql:/var/lib/jenkins/workspace/postgis/branches/3.5/regress/00
 -regress-install/share/contrib/postgis/uninstall_postgis.sql:87: ERROR:
 cannot drop operator @(geometry,geometry) because other objects depend on
 it
 04:49:03 DETAIL:  constraint enforce_max_extent_rast on table loadedrast
 depends on operator @(geometry,geometry)
 04:49:03 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 04:49:03
 -----------------------------------------------------------------------------
 04:49:03 . failed (Object count pre-install (5419) != post-uninstall
 (6903))
 04:49:03
 }}}

 Also same failure on 3.4.

 What's weird is it started failing after commit [b0943c0abe/git]

 But I should not it's only failing on PG16 and 17 runs which that
 particular ticket targets
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5650>
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.