[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
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Okay this sucks. I thought it was just debbie, but even I'm running into
 the issue and GHA is running into the issue with the PG16 and PG17 run

 https://github.com/postgis/postgis/actions/runs/7335081499/job/19972577805


 {{{
 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/uninstall_topology.sql:330: NOTICE:  New
 search_path: "$user", public
                  stripfromsearchpath
 ------------------------------------------------------
  topology has been stripped off database search_path
 (1 row)

 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/uninstall_topology.sql:332: NOTICE:  drop
 cascades to function undef_helper.stripfromsearchpath(character varying)
 NOTICE:  schema "public" already exists, skipping
 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/uninstall_rtpostgis.sql:70: ERROR:  cannot
 drop function st_envelope(raster) because other objects depend on it
 DETAIL:  constraint enforce_max_extent_rast on table loadedrast depends on
 function st_envelope(raster)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 NOTICE:  schema "public" already exists, skipping
 NOTICE:  schema "public" already exists, skipping
 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/uninstall_postgis.sql:87: ERROR:  cannot
 drop operator @(geometry,geometry) because other objects depend on it
 DETAIL:  constraint enforce_max_extent_rast on table loadedrast depends on
 operator @(geometry,geometry)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 -----------------------------------------------------------------------------
 . failed (Object count pre-install (5419) != post-uninstall (6903))
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5650#comment:1>
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.