[postgis-tickets] [PostGIS] #5017: topology.ValidateTopology error relation "shell_check" already exists

[PostGIS]

#5017: topology.ValidateTopology error relation "shell_check" already exists
-----------------------+---------------------------
  Reporter:  laopsahl  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.1.5
 Component:  postgis   |    Version:  2.5.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by strk):

 I cannot reproduce. What version of postgis ?
 {{{
 strk=# begin;
 BEGIN
 strk=# select * from validatetopology('city_data');
 NOTICE:  Checking for coincident nodes
 NOTICE:  Checking for edges crossing nodes
 NOTICE:  Checking for invalid or not-simple edges
 NOTICE:  Checking for crossing edges
 NOTICE:  Checking for edges start_node mismatch
 NOTICE:  Checking for edges end_node mismatch
 NOTICE:  Checking for faces without edges
 NOTICE:  Checking edge linking
 NOTICE:  Building edge rings
 NOTICE:  Found 315 rings, 310 valid shells, 5 valid holes
 NOTICE:  Constructing geometry of all faces
 NOTICE:  Checking faces
 NOTICE:  Checked 310 faces
 NOTICE:  Checking for holes coverage
 NOTICE:  Finished checking for coverage of 5 holes
 NOTICE:  Checking for node containing_face correctness
  error | id1 | id2
 -------+-----+-----
 (0 rows)

 strk=# select * from validatetopology('city_data');
 NOTICE:  Checking for coincident nodes
 NOTICE:  Checking for edges crossing nodes
 NOTICE:  Checking for invalid or not-simple edges
 NOTICE:  Checking for crossing edges
 NOTICE:  Checking for edges start_node mismatch
 NOTICE:  Checking for edges end_node mismatch
 NOTICE:  Checking for faces without edges
 NOTICE:  Checking edge linking
 NOTICE:  Building edge rings
 NOTICE:  Found 315 rings, 310 valid shells, 5 valid holes
 NOTICE:  Constructing geometry of all faces
 NOTICE:  Checking faces
 NOTICE:  Checked 310 faces
 NOTICE:  Checking for holes coverage
 NOTICE:  Finished checking for coverage of 5 holes
 NOTICE:  Checking for node containing_face correctness
  error | id1 | id2
 -------+-----+-----
 (0 rows)

 strk=# select postgis_full_version();
 postgis_full_version
 POSTGIS="3.2.0dev 3.2.0alpha1-53-g6c2131ddc" [EXTENSION] PGSQL="120"
 GEOS="3.10.0-CAPI-1.16.0" PROJ="7.1.0" GDAL="GDAL 3.2.2, released
 2021/03/05" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.3.3"
 WAGYU="0.5.0 (Internal)" (core procs from "3.2.0dev
 3.1.0rc1-392-g4f6e4bd36" need upgrade) TOPOLOGY (topology procs from
 "3.2.0dev 3.1.0rc1-392-g4f6e4bd36" need upgrade) RASTER (raster procs from
 "3.2.0dev 3.1.0rc1-392-g4f6e4bd36" need upgrade)
 (1 row)
 }}}

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