[postgis-users] Signal 11: Segmentation fault

[Rebecca Clarke]

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.clarke83 at 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 <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/59c864e5/attachment.html>