Hi, thx from your advice, I dropped topology DP_TOPO2 and create new one called dp_topo. I didn't get the error, but the query still working (11 hours). I expected long time for it because it's working with 7000 polygons, but Is it still normal?
Eva 2013/5/18 Paragon Corporation <[email protected]> > ** > 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:* [email protected] [mailto: > [email protected]] *On Behalf Of *Eva Linhartová > *Sent:* Saturday, May 18, 2013 6:18 AM > *To:* [email protected] > *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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
