[postgis-tickets] [PostGIS] #5484: ERROR: cannot drop function st_value(raster, geometry, boolean) because other objects depend on it

[PostGIS]

#5484: ERROR:  cannot drop function st_value(raster,geometry,boolean) because
other objects depend on it
------------------------------------+----------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.1.10
 Component:  build/upgrade/install  |    Version:  2.1.x
Resolution:                         |   Keywords:
------------------------------------+----------------------------
Changes (by strk):

 * version:  3.4.x => 2.1.x
 * milestone:  PostGIS 3.4.1 => PostGIS 3.1.10

Comment:

 It looks like the name of the third (boolean) argument was changed in 2.1:

    - stable-2.0: st_value(rast raster, pt geometry, hasnodata boolean
 DEFAULT TRUE)
    - stable-2.1: st_value(rast raster, pt geometry, exclude_nodata_value
 boolean DEFAULT TRUE)

 This explain the presence of the signature in
 `rtpostgis_upgrade_cleanup.sql`

 Support for `Replaces` comment entered the codebase with 3.1
 ([3d947448b9c939b321bc22b85c719845722ecc3d/git]) so we can try fixing this
 bug with a Replaces coment, although it wasn't specifically written for
 parameters renames.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5484#comment:6>
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.