[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] st_isvalid stop the server
From: Stephen Woodbridge <woodbri () swoodbridge ! com>
Date: 2010-05-30 14:41:31
Message-ID: 4C02791B.7040602 () swoodbridge ! com
[Download RAW message or body]
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@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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic