[postgis-tickets] [PostGIS] #5354: ERROR: function "_postgis_join_selectivity" already exists with same argument types

[PostGIS]

#5354: ERROR:  function "_postgis_join_selectivity" 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:  master
 Keywords:                         |
-----------------------------------+---------------------------
 On my local dump restore test using:


 {{{
 make check RUNTESTFLAGS="-v --dumprestore"
 }}}

 , I am getting error


 {{{
 ERROR:  function "_postgis_join_selectivity" already exists with same
 argument types

 }}}


 full output is


 {{{
 Checking for shp2pgsql ... found
 Checking for pgsql2shp ... found
 Checking for raster2pgsql ... found
 Creating database 'postgis_reg-3.4'
 Loading unpackaged components from /projects/postgis/postgis-
 git/regress/00-regress-install/share/contrib/postgis
 Loading PostGIS into 'postgis_reg-3.4'
 Loading Topology into 'postgis_reg-3.4'
 Loading Raster into 'postgis_reg-3.4'
 Loading SFCGAL into 'postgis_reg-3.4'
 Dumping database 'postgis_reg-3.4'
 Dropping db 'postgis_reg-3.4'
 Creating db 'postgis_reg-3.4'
 Loading unpackaged components from /projects/postgis/postgis-
 git/regress/00-regress-install/share/contrib/postgis
 Loading PostGIS into 'postgis_reg-3.4'
 Loading Topology into 'postgis_reg-3.4'
 Loading Raster into 'postgis_reg-3.4'
 Loading SFCGAL into 'postgis_reg-3.4'
 Restoring database 'postgis_reg-3.4' using postgis_restore.pl
 Converting
 /projects/postgis/tmp/3.4.0dev_pg16_geos3.12_gdal3.4.3w64/postgis_reg-3.4.dump
 to ASCII on stdout...
   Reading list of functions to ignore...
   Writing manifest of things to read from dump file...
 Setting postgis schema to public, as found in the dump  Writing ASCII to
 stdout...
 Done.
  failed (Could not restore postgis_reg-3.4:
 /projects/postgis/tmp/3.4.0dev_pg16_geos3.12_gdal3.4.3w64/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:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/topology.sql:377: NOTICE:  constraint
 "type_range" of domain "topology.topoelement" does not exist, skipping
 psql:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/topology.sql:675: NOTICE:  function
 topology.populate_topology_layer() does not exist, skipping
 psql:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/topology.sql:2927: 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
 NOTICE:  schema "public" already exists, skipping
 NOTICE:  schema "public" already exists, skipping
 NOTICE:  schema "public" already exists, skipping
 psql:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/sfcgal.sql:182: WARNING:  there is no
 transaction in progress
 psql:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/sfcgal.sql:190: WARNING:  there is no
 transaction in progress
 psql:C:/ming64gcc81/projects/postgis/postgis-git/regress/00-regress-
 install/share/contrib/postgis/sfcgal.sql:198: WARNING:  there is no
 transaction in progress
 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 "_postgis_join_selectivity" already exists with same
 argument types
 -----------------------------------------------------------------------------
 Died at ./regress/run_test.pl line 399.
 make: *** [regress/runtest.mk:24: check-regress] Error 3

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