[PostGIS] #5496: ST_Clip(raster, geom) include new method to pixel selection: touch

[PostGIS]

#5496: ST_Clip(raster, geom) include new method to pixel selection: touch
--------------------------+---------------------------
  Reporter:  latot        |      Owner:  robe
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.5.0
 Component:  raster       |    Version:  3.4.x
Resolution:               |   Keywords:
--------------------------+---------------------------
Comment (by robe):

 The failure for the upgrade test is this:


 {{{
 psql:/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/build/pg12/regress/00
 -regress-install/share/contrib/postgis/rtpostgis_upgrade.sql:10000:
 WARNING:  Deprecated function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean) left
 behind: cannot drop function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean) because
 other objects depend on it
 DETAIL:  view upgrade_test_raster_view_st_clip depends on function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean)
 HINT:  Replace the view changing all occurrences of
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean) in its
 definition with st_clip and upgrade again
 NOTICE:  schema "public" already exists, skipping
 NOTICE:  schema "public" already exists, skipping
 psql:/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/regress/hooks
 /hook-after-upgrade.sql:14: NOTICE:  schema "postgis_upgrade_test_data"
 does not exist, skipping
 psql:/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/regress/hooks
 /hook-after-upgrade.sql:29: NOTICE:  Dropping function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean)
 psql:/woodpecker/src/git.osgeo.org/gitea/postgis/postgis/regress/hooks
 /hook-after-upgrade.sql:29: ERROR:  cannot drop function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean) because
 other objects depend on it
 DETAIL:  view upgrade_test_raster_view_st_clip depends on function
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 CONTEXT:  SQL statement "DROP FUNCTION
 st_clip_deprecated_by_postgis_305(raster,geometry,boolean,boolean)"
 PL/pgSQL function inline_code_block line 10 at EXECUTE
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5496#comment:7>
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.