[postgis-users] postgis topology

[Paragon Corporation]

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-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Eva Linhartová
Sent: Saturday, May 18, 2013 6:18 AM
To: postgis-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130518/c67edf7b/attachment.html>