[postgis-users] Crashed Server with exteriorring()

Stephen Woodbridge woodbri at swoodbridge.com
Sun Dec 18 11:27:03 PST 2005


While trying various random queries to test out how things work I ran 
into this problem.


select exteriorring(geometryn(the_geom,1)) from county where gid=1398;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

select isvalid(geometryn(the_geom,1)) from county where gid=1398;
t

select geometrytype(the_geom) from county where gid=1398
"MULTIPOLYGON"

select geometrytype(geometryn(the_geom,1)) from county where gid=1398
"POLYGON"

"POSTGIS="1.0.5" GEOS="2.2.0" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS 
DBPROC="0.3.0" RELPROC="0.3.0""

"PostgreSQL 8.0.4 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 
3.4.2 [FreeBSD] 20040728"

I can send you a shapefile with this polygon is you need it.

-Steve



More information about the postgis-users mailing list