[postgis-tickets] [PostGIS] #3016: DropTopology raises an exception on corrupted topology schema

PostGIS trac at osgeo.org
Wed Jan 21 05:04:03 PST 2015


#3016: DropTopology raises an exception on corrupted topology schema
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.1.6
Component:  topology  |     Version:  2.1.x        
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by strk):

 The exception comes from the attempt to drop the registered (but missing)
 layers:
 {{{
 NOTICE:  Dropping all layers from topology topo_235bis (1295)
 ERROR:  relation "topo_235bis.relation" does not exist
 LINE 1: DELETE FROM topo_235bis.relation  WHERE layer_id = 1
                     ^
 QUERY:  DELETE FROM topo_235bis.relation  WHERE layer_id = 1
 CONTEXT:  PL/pgSQL function droptopogeometrycolumn(character
 varying,character varying,character varying) line 33 at EXECUTE statement
 SQL statement "SELECT
 topology.DropTopoGeometryColumn('topo_235bis','LAYER1','')"
 PL/pgSQL function droptopology(character varying) line 22 at EXECUTE
 statement
 }}}

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


More information about the postgis-tickets mailing list