<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16576"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial>Is your schema called DP_TOPO2 or
dp_topo2?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 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 class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 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 class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/support">http://postgis.net/support</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 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 class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial><FONT color=#0000ff size=2
face=Arial></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 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 class=489213717-18052013></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=489213717-18052013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Eva
Linhartová<BR><B>Sent:</B> Saturday, May 18, 2013 6:18 AM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] postgis
topology<BR></FONT><BR></DIV>
<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></BODY></HTML>