Is your schema called DP_TOPO2 or dp_topo2? Stay away from upper or mixed case names for schemas, column names and tables. It will only cause you frustration in the long run. That aside this looks like a bug in topology itself that it is not handling mixed case, upper case schemas. Please post a bug ticket as detailed here: http://postgis.net/support The topology code should be really doing SELECT nextval('"DP_TOPO2".node_node_id_seq') but looks like its probably not using quote_ident to determine that. Hope that helps, Regina http://www.postgis.us http://postgis.net
_____ From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Eva Linhartová Sent: Saturday, May 18, 2013 6:18 AM To: postgis-users@lists.osgeo.org Subject: [postgis-users] postgis topology 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 postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users