[postgis-tickets] [PostGIS] #5415: dump restore failure function "st_largestemptycircle" already exists with same argument types

[PostGIS]

#5415: dump restore failure function "st_largestemptycircle" already exists with
same argument types
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 3.4.0
 Component:  build/upgrade/install  |    Version:  3.3.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Description changed by robe:

Old description:

> Seeing this error on gitlab dump/restore with new function
> {{{
> Died at /builds/postgis/postgis/regress/run_test.pl line 426.
>  failed (Could not restore postgis_reg-3.4: /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
> psql:/tmp/build/regress/00-regress-
> install/share/contrib/postgis/topology.sql:388: NOTICE:  constraint
> "type_range" of domain "topology.topoelement" does not exist, skipping
> psql:/tmp/build/regress/00-regress-
> install/share/contrib/postgis/topology.sql:686: NOTICE:  function
> topology.populate_topology_layer() does not exist, skipping
> psql:/tmp/build/regress/00-regress-
> install/share/contrib/postgis/topology.sql:2938: NOTICE:  aggregate
> topology.topoelementarray_agg(topology.topoelement) does not exist,
> skipping
>                      addtosearchpath
> ---------------------------------------------------------
>  topology has been added to end of database search_path
> (1 row)
> NOTICE:  schema "public" already exists, skipping
> SET
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> SELECT 8500
> DELETE 8500
> SET
> SET
> SET
> SET
> SET
>  set_config
> ------------
>
> (1 row)
> SET
> SET
> SET
> SET
> ERROR:  function "st_largestemptycircle" already exists with same
> argument types
> -----------------------------------------------------------------------------
> make: *** [/builds/postgis/postgis/regress/runtest.mk:24: check-regress]
> Error 3
> }}}

New description:

 Seeing this error on gitlab dump/restore with new function
 https://gitlab.com/postgis/postgis/-/jobs/4562298119#L4500
 {{{
 Died at /builds/postgis/postgis/regress/run_test.pl line 426.
  failed (Could not restore postgis_reg-3.4: /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
 psql:/tmp/build/regress/00-regress-
 install/share/contrib/postgis/topology.sql:388: NOTICE:  constraint
 "type_range" of domain "topology.topoelement" does not exist, skipping
 psql:/tmp/build/regress/00-regress-
 install/share/contrib/postgis/topology.sql:686: NOTICE:  function
 topology.populate_topology_layer() does not exist, skipping
 psql:/tmp/build/regress/00-regress-
 install/share/contrib/postgis/topology.sql:2938: NOTICE:  aggregate
 topology.topoelementarray_agg(topology.topoelement) does not exist,
 skipping
                      addtosearchpath
 ---------------------------------------------------------
  topology has been added to end of database search_path
 (1 row)
 NOTICE:  schema "public" already exists, skipping
 SET
 ALTER TABLE
 ALTER TABLE
 ALTER TABLE
 SELECT 8500
 DELETE 8500
 SET
 SET
 SET
 SET
 SET
  set_config
 ------------

 (1 row)
 SET
 SET
 SET
 SET
 ERROR:  function "st_largestemptycircle" already exists with same argument
 types
 -----------------------------------------------------------------------------
 make: *** [/builds/postgis/postgis/regress/runtest.mk:24: check-regress]
 Error 3
 }}}

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