[postgis-users] Signal 11: Segmentation fault

[Rebecca Clarke]

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 <strk at 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------'
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120725/fea9a152/attachment.html>