[postgis-tickets] [PostGIS] #5488: Upgrade from 3.1.1: ERROR: cannot drop function st_clip(raster, integer, geometry, double precision, boolean) because other objects depend on it
PostGIS
trac at osgeo.org
Mon Aug 28 10:05:29 PDT 2023
#5488: Upgrade from 3.1.1: ERROR: cannot drop function
st_clip(raster,integer,geometry,double precision,boolean) because other
objects depend on it
------------------------------------+------------------
Reporter: strk | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone:
Component: build/upgrade/install | Version:
Resolution: | Keywords:
------------------------------------+------------------
Comment (by strk):
The current definition of that function in raster/rt_pg/rtpostgis.sql.in
is:
{{{
CREATE OR REPLACE FUNCTION st_clip(
rast raster, nband integer,
geom geometry,
nodataval double precision, crop boolean DEFAULT TRUE
)
}}}
The rtpostgis_upgrade_cleanup.sql.in file drops all of these:
{{{
DROP FUNCTION IF EXISTS st_clip(raster, integer, geometry, boolean);
DROP FUNCTION IF EXISTS st_clip(raster, geometry, float8, boolean);
DROP FUNCTION IF EXISTS st_clip(raster, geometry, boolean);
DROP FUNCTION IF EXISTS st_clip(raster, int, geometry, float8, boolean);
DROP FUNCTION IF EXISTS st_clip(raster, geometry, float8[], boolean);
DROP FUNCTION IF EXISTS st_clip(raster, integer, geometry, float8[],
boolean);
}}}
Saying, in a comment, that their signature changed (the comment does not
say when and how)
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5488#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.
More information about the postgis-tickets
mailing list