[postgis-devel] Topology modelling RFC

[Stephen Campbell]

|| 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