[postgis-users] st_isvalid stop the server

[Richard Greenwood]

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 <pramsey at 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.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
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com