[postgis-tickets] [PostGIS] #3568: Backend crash on TopoGeo_addLinestring

PostGIS trac at osgeo.org
Tue Jun 7 14:18:24 PDT 2016


#3568: Backend crash on TopoGeo_addLinestring
-----------------------+---------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  blocker   |  Milestone:  PostGIS 2.3.0
 Component:  topology  |    Version:  trunk
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by strk):

 The query I'm using against the whole "ucs_rt" table, which can be found
 here:
 http://www502.regione.toscana.it/geoscopio/topologia_uso_suolo.7z

 Is as follows:

 {{{
 DO $$
 declare
   rec record;
 begin
   for rec in select gid, (ST_Dump(ST_Boundary(geom))).* from ucs_rt
       order by st_length(geom)
       offset 65000 limit 11000
   loop
     begin
       perform topology.TopoGeo_addLinestring('ucs_rt_topo', rec.geom);
     exception when others then
       RAISE WARNING 'Error adding boundary line % of record with gid %:
 %',
         rec.path, rec.gid, SQLERRM;
       insert into ucs_rt_topo.problematic values ( rec.geom );
     end;
   end loop;
 end;
 $$ language 'plpgsql';
 }}}

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