I don't get the error when I do this though: SELECT ST_IsValid(st_astext(the_geom)::geometry) FROM tbl where id = 6052;
returns true. On Wed, Jul 25, 2012 at 3:17 PM, Rebecca Clarke <r.clark...@gmail.com>wrote: > I get the following error when I do the round-trip. > > ERROR: parse error - invalid geometry > HINT: You must specify a valid OGC WKT geometry type such as POINT, > LINESTRING or POLYGON > > > \d tbl > > Table "tbl" > Column | Type | > Modifiers > > --------------------+-------------------+----------------------------------------------------------------------------------------- > the_geom | bytea | > > > > I was getting the error when I was using Postgresql 8.4 and postgis 1.5.1 > as well. > I redeveloped the database on a new server with the latest versions in > hopes it will resolve the issue. > > > On Wed, Jul 25, 2012 at 3:08 PM, Sandro Santilli <s...@keybit.net> wrote: > >> 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