[postgis-users] postgis topology

[Eva Linhartová]

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 <lr at pcorp.us>

> **
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130519/edab45a4/attachment.html>