Hi,
I'm trying to insert geometry data to topology structure. I tryed it on my
sample data before and it was ok, but now if I use polygon table with 7000
polygons or 20000 lines can't work.
I get error like:
ERROR: schema "dp_topo2" does not exist
LINE 1: SELECT nextval('DP_TOPO2.node_node_id_seq')
ERROR: schema "dp_topo2" does not exist
Stav SQL: 3F000
SET search_path TO dp, topology, public;
SELECT CreateTopology('DP_TOPO2',2065,0.005); -- 1491 ms
SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'ku', 'topo', 'POLYGON');
-- 301ms
SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'body', 'topo', 'POINT');
-- 701ms
SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'plochy', 'topo',
'POLYGON'); -- 298ms
SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'linie', 'topo',
'LINESTRING'); -- 171ms
UPDATE ku SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',1,0.005); --
687ms
UPDATE body SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',2,0.005); --
164274ms
UPDATE plochy SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',3,0.005); --
dp_topo2 does not exist
UPDATE linie SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',4,0.005); --
dp_topo2 does not exist
I'm newbie in geodatabase and in PostGIS so I have no idea what can I do to
fix this problem.
I'll appreciate some help.
Thx Eva
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
