[postgis-users] st_isvalid stop the server

Colin East colin.east at geospatial-ict.com.au
Sat May 29 22:58:45 PDT 2010

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 
(Note: this query also kills the win2008 server)

Why would running a PostGIS function stop the server???



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100530/75cdfc2b/attachment.html>

More information about the postgis-users mailing list