[postgis-users] st_isvalid stop the server

[Paul Ramsey]

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.east at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>