[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 can reproduce. It occurs when topology errors are found:
 {{{
 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, 309 valid shells, 5 valid holes
             error            | id1  | id2
 -----------------------------+------+-----
  mixed face labeling in ring | -153 |
 (1 row)

 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
 ERROR:  relation "shell_check" already exists
 CONTEXT:  SQL statement "CREATE TEMP TABLE shell_check (
     face_id int PRIMARY KEY,
     ring_geom geometry
   )"
 PL/pgSQL function _validatetopologyrings(geometry) line 12 at SQL
 statement
 PL/pgSQL function validatetopology(character varying,geometry) line 300 at
 FOR over SELECT rows
 }}}

 Your errors are actual errors, not just missing data

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