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