<div dir="ltr">Hi,<div>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?</div>
<div><br></div><div>Eva </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/5/18 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Is your schema called DP_TOPO2 or
dp_topo2?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Stay away from upper or mixed case names for schemas, column
names and tables. It will only cause you frustration in the long
run.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">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:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net/support" target="_blank">http://postgis.net/support</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">The topology code should be really doing <font color="#000000" size="3" face="Times New Roman">SELECT nextval('"DP_TOPO2".node_node_id_seq')
</font></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><font color="#0000ff" face="Arial"></font></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><font color="#000000" size="3" face="Times New Roman">but looks
like its probably not using quote_ident to determine
that.</font></font></span></div>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net" target="_blank">http://postgis.net</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Eva
Linhartová<br><b>Sent:</b> Saturday, May 18, 2013 6:18 AM<br><b>To:</b>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] postgis
topology<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr">Hi,
<div>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. </div>
<div><br></div>
<div>I get error like: </div>
<div><br></div>
<div>
<div>ERROR: schema "dp_topo2" does not exist</div>
<div>LINE 1: SELECT nextval('DP_TOPO2.node_node_id_seq')</div></div>
<div><br></div>
<div>
<div>ERROR: schema "dp_topo2" does not exist</div>
<div>Stav SQL: 3F000</div></div>
<div><br></div>
<div>
<div>SET search_path TO dp, topology, public;</div>
<div>SELECT CreateTopology('DP_TOPO2',2065,0.005); -- 1491 ms</div>
<div><br></div>
<div>SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'ku', 'topo', 'POLYGON');
-- 301ms</div>
<div>SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'body', 'topo', 'POINT');
-- 701ms</div>
<div>SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'plochy', 'topo',
'POLYGON'); -- 298ms</div>
<div>SELECT AddTopoGeometryColumn('DP_TOPO2', 'dp', 'linie', 'topo',
'LINESTRING'); -- 171ms</div>
<div><br></div>
<div><br></div>
<div>UPDATE ku SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',1,0.005);
-- 687ms</div>
<div>UPDATE body SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',2,0.005); --
164274ms</div>
<div>UPDATE plochy SET topo = topology.toTopoGeom(geom,
'DP_TOPO2',3,0.005); -- dp_topo2 does not exist</div>
<div>UPDATE linie SET topo = topology.toTopoGeom(geom, 'DP_TOPO2',4,0.005); --
dp_topo2 does not exist</div></div>
<div><br></div>
<div>I'm newbie in geodatabase and in PostGIS so I have no idea what can I do to
fix this problem.</div>
<div>I'll appreciate some help.</div>
<div><br></div>
<div>Thx Eva</div></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>