[postgis-tickets] [PostGIS] #5576: restoring dump from 3.x: ERROR: function "st_mapalgebrafct" already exists with same argument types

[PostGIS]

#5576: restoring dump from 3.x: ERROR:  function "st_mapalgebrafct" already exists
with same argument types
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.4.1
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by strk):

 The `run_test.pl` script keeps the dump and the manifest so I can tell the
 dump contains these signatures:
 {{{
 1165; 1255 32872139 FUNCTION public st_mapalgebrafct(public.raster,
 regprocedure, text[]) strk
 1162; 1255 32872135 FUNCTION public st_mapalgebrafct(public.raster,
 integer, regprocedure, text[]) strk
 1163; 1255 32872137 FUNCTION public st_mapalgebrafct(public.raster, text,
 regprocedure, text[]) strk
 1145; 1255 32872133 FUNCTION public st_mapalgebrafct(public.raster,
 integer, text, regprocedure, text[]) strk
 1170; 1255 32872144 FUNCTION public st_mapalgebrafct(public.raster,
 public.raster, regprocedure, text, text, text[]) strk
 1169; 1255 32872143 FUNCTION public st_mapalgebrafct(public.raster,
 integer, public.raster, integer, regprocedure, text, text, text[]) strk
 }}}

 While the SKIP list has these:
 {{{
 FUNCTION st_mapalgebrafct(raster, integer, raster, integer, regprocedure,
 text, text, userargs text[])
 FUNCTION st_mapalgebrafct(raster, integer, regprocedure)
 FUNCTION st_mapalgebrafct(raster, integer, regprocedure, args text[])
 FUNCTION st_mapalgebrafct(raster, integer, text, regprocedure)
 FUNCTION st_mapalgebrafct(raster, integer, text, regprocedure, args
 text[])
 FUNCTION st_mapalgebrafct(raster, raster, regprocedure, text[])
 FUNCTION st_mapalgebrafct(raster, raster, regprocedure, text, text,
 userargs text[])
 FUNCTION st_mapalgebrafct(raster, regprocedure)
 FUNCTION st_mapalgebrafct(raster, regprocedure, args text[])
 FUNCTION st_mapalgebrafct(raster, text, regprocedure)
 FUNCTION st_mapalgebrafct(raster, text, regprocedure, args text[])
 }}}

 The problem seem to be that we're keeping the "args" and "userargs"
 parameter names in those skip signatures.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5576#comment:2>
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.