Quit test of st_isvalid() on Win2008 R2, EnterpriseDB installer Postgres 8.4.3, PostGIS 1.4 works fine, no problems here.
Reagrds, Rich On Sun, May 30, 2010 at 6:16 AM, Paul Ramsey <pram...@opengeo.org> wrote: > Sounds like all calls to st_isvalid fail, yes? As you can imagine, > this is not behaviour we see on other platforms. I wonder if anyone > else on Win2008 Server using the EBD distribution see a similar thing? > > P > > On Sun, May 30, 2010 at 1:58 AM, Colin East > <colin.e...@geospatial-ict.com.au> 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@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users