[PostGIS] #5498: ERROR: function st_approxquantile(raster, double precision) is not unique

[PostGIS]

#5498: ERROR:  function st_approxquantile(raster, double precision) is not unique
---------------------+---------------------------
  Reporter:  strk    |      Owner:  robe
      Type:  defect  |     Status:  reopened
  Priority:  medium  |  Milestone:  PostGIS 3.6.0
 Component:  raster  |    Version:  master
Resolution:          |   Keywords:
---------------------+---------------------------
Changes (by robe):

 * resolution:  fixed =>
 * status:  closed => reopened

Comment:

 Looks like dronie and woodie are failing with this error upgrading from
 3.1


 {{{
 Loading PostGIS in 'postgis_reg using scripts from
 /usr/share/postgresql/14/contrib/postgis-3.1'

 Loading Raster into 'postgis_reg'

 Restoring database 'postgis_reg' using postgis_restore.pl

 Done.

 Died at /drone/src/regress/run_test.pl line 454.

 gmake: *** [/drone/src/regress/runtest.mk:24: check-regress] Error 3

  failed (Could not restore postgis_reg: /tmp/pgis_reg/regress_log)

 -----------------------------------------------------------------------------

 NOTICE:  schema "public" already exists, skipping

 NOTICE:  schema "public" already exists, skipping

 NOTICE:  schema "public" already exists, skipping

 NOTICE:  schema "public" already exists, skipping

 NOTICE:  schema "public" already exists, skipping

 SET

 ALTER TABLE

 ALTER TABLE

 SELECT 8500

 DELETE 8500

 SET

 SET

 SET

 SET

 SET

  set_config

 ------------



 (1 row)


 SET

 SET

 SET

 SET

 ERROR:  function "st_approxquantile" already exists with same argument
 types

 -----------------------------------------------------------------------------

 gmake: Leaving directory '/tmp/postgis-build/14/raster/test/regress'

 FAIL: postgis_raster script hard upgrade unpackaged3.1--:auto

 Cleaning up so I must have missed something.
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5498#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.