[postgis-users] Signal 11: Segmentation fault

[Sandro Santilli]

On Wed, Jul 25, 2012 at 02:59:24PM +0100, Rebecca Clarke wrote:
> There is no index on the table.

Ok.

Does a round-trip (print->parse) work? :

  SELECT ST_IsValid(the_geom::text::geometry) FROM tbl where id = 6052;

Can you also show the result of:

 \d tbl

or at least the portion mentioning "the_geom"

> postgis_full_version
> -------------------------------------------------------------------------------------------------------
>  POSTGIS="1.5.5" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September
> 2009" LIBXML="2.7.8" USE_STATS

Uhm, it may have to do with the GEOS version, can you try upgrading that as well ?

> version
> -------------------------------------------------------------------------------------------------------
>  PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
> (Debian 4.4.5-8) 4.4.5, 64-bit
> 
> 
> Until this Monday, I was using Postgresql 8.4 and postgis  1.5.1

Are you saying your queries were working before the upgrade ?

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.1
  |  / 2.1 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'