[postgis-users] postgis topology

[Eva Linhartová]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130518/19f4ecbf/attachment.html>