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

PostGIS trac at osgeo.org
Mon Nov 8 03:51:17 PST 2021


#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
 Keywords:            |
----------------------+---------------------------
 When I run topology.ValidateTopology second time without starting a new
 session there is temp table not removed.

 {{{
 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

 }}}

 If I close the session and opens a new one it works ok.

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


More information about the postgis-tickets mailing list