[postgis-tickets] [PostGIS] #5078: 2.5.6dev--3.3.0dev upgrade fails: cannot change name of input parameter "param_geom"

[PostGIS]

#5078: 2.5.6dev--3.3.0dev upgrade fails: cannot change name of input parameter
"param_geom"
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.3.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Description changed by strk:

Old description:

> Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION
> '2.5.6dev' SCHEMA public
> Upgrading from postgis 2.5.6dev
> Running before-upgrade-script ../regress/hooks/hook-before-upgrade.sql
> Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
> TO '3.3.0dev'
>  failed (Error encountered updating EXTENSION POSTGIS:
> /tmp/pgis_reg/regress_log)
> -----------------------------------------------------------------------------
> NOTICE:  schema "public" already exists, skipping
> CREATE SCHEMA
> CREATE EXTENSION
> NOTICE:  schema "public" already exists, skipping
> CREATE SCHEMA
> SET
> CREATE TABLE
> INSERT 0 2
> DO
> CREATE VIEW
> CREATE VIEW
> CREATE VIEW
> CREATE VIEW
> CREATE VIEW
> CREATE VIEW
> UPDATE 592
> WARNING:  unpackaging raster
> WARNING:  PostGIS Raster functionality has been unpackaged
> HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade.
> After upgrading, if you want to drop raster, run: DROP EXTENSION
> postgis_raster;
> ERROR:  cannot change name of input parameter "param_geom"
> HINT:  Use DROP FUNCTION st_concavehull(geometry,double
> precision,boolean) first.
> -----------------------------------------------------------------------------

New description:

 {{{
 $ regress/run_test.pl --extension --upgrade --upgrade-path 2.5.6dev--
 3.3.0dev regress/core/regress -v
 [...]
 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION
 '2.5.6dev' SCHEMA public
 Upgrading from postgis 2.5.6dev
 Running before-upgrade-script ../regress/hooks/hook-before-upgrade.sql
 Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
 TO '3.3.0dev'
  failed (Error encountered updating EXTENSION POSTGIS:
 /tmp/pgis_reg/regress_log)
 -----------------------------------------------------------------------------
 NOTICE:  schema "public" already exists, skipping
 CREATE SCHEMA
 CREATE EXTENSION
 NOTICE:  schema "public" already exists, skipping
 CREATE SCHEMA
 SET
 CREATE TABLE
 INSERT 0 2
 DO
 CREATE VIEW
 CREATE VIEW
 CREATE VIEW
 CREATE VIEW
 CREATE VIEW
 CREATE VIEW
 UPDATE 592
 WARNING:  unpackaging raster
 WARNING:  PostGIS Raster functionality has been unpackaged
 HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade.
 After upgrading, if you want to drop raster, run: DROP EXTENSION
 postgis_raster;
 ERROR:  cannot change name of input parameter "param_geom"
 HINT:  Use DROP FUNCTION st_concavehull(geometry,double precision,boolean)
 first.
 -----------------------------------------------------------------------------
 }}}

--

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5078#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.