[postgis-users] st_isvalid stop the server

Stephen Woodbridge woodbri at swoodbridge.com
Sun May 30 07:41:31 PDT 2010


Does any PostGIS function work? like:

select astext(the_geom) from roadassets where gid=1;
select st_length(the_geom) from roadassets where gid=1;

-Steve W.

Colin East wrote:
> 
> When I run this query my PostgreSQL server stops!!
> 
> SELECT ST_IsValid(the_geom)
> FROM roadassets
> WHERE gid = 1;
> 
> If I run something like 'select * from roadassets;' all is fine.
> 
> I'm running win2008 standard server on VirtualBox hosted on a Ubuntu 
> 10.04 desktop. The PostgreSQL/PostGIS install was done using the 
> EnterpriseDB installer - port 5433 - (I have posted this issue on the 
> EnterpriseDB forum too). Queries are run using PGAdmin on the Ubuntu 
> 10.04 desktop.
> 
> Further information:
> The event log in windows says 'Failed to query jobs table!'
> I have another PostgeSQL/PostGIS (8.4.4/1.5.1) instance running on the 
> Ubuntu desktop and the following query works ok:
> SELECT ST_IsValid(ST_GeomFromText('LINESTRING(0 0, 1 1)')) As good_line,
>     ST_IsValid(ST_GeomFromText('POLYGON((0 0, 1 1, 1 2, 1 1, 0 0))')) As 
> bad_poly
> (Note: this query also kills the win2008 server)
> 
> Why would running a PostGIS function stop the server???
> 
> Cheers
> 
> Colin
> 
> 
> 
> 
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list