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
