[postgis-devel] Topology modelling RFC
strk at refractions.net
strk at refractions.net
Mon Oct 17 03:29:02 PDT 2005
Stephen, we need to keep the queries simple, so let Topology alone ;)
The GeometryN segfault is enough for now, but unfortunately I don't
have a sparcv7 to test this on. Can you provide a remote access
to that machine ?
--strk;
On Sat, Oct 15, 2005 at 08:44:54PM +1300, Stephen Campbell wrote:
> || On Fri, 14 Oct 2005 14:45:03 +0200
> || In mail titled "[postgis-devel] Topology modelling RFC"
> || strk at refractions.net said, and I quote:
> []
>
> I get this right on the last query of the load_topology.sql
> just before the "END;" (BTW: this is on the saprcv7 (32bit).
>
>
> SELECT a.feature_name, id(a.feature) as tg_id,
> astext(topology.Geometry(a.feature)) as geom
> FROM features.traffic_signs a;
> feature_name | tg_id | geom
> --------------+-------+--------------
> S1 | 1 | POINT(21 14)
> S2 | 2 | POINT(35 14)
> S3 | 3 | POINT(57 33)
> S4 | 4 | POINT(20 37)
> (4 rows)
>
> SELECT a.feature_name, id(a.feature) as tg_id,
> astext(topology.Geometry(a.feature)) as geom
> FROM features.city_streets a;
> psql:load_topology.sql:342: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> psql:load_topology.sql:342: connection to server was lost
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
More information about the postgis-devel
mailing list