[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