[postgis-users] Signal 11: Segmentation fault

[Rebecca Clarke]

Sorry. I was meaning the data type of the column is bytea.

On Wed, Jul 25, 2012 at 3:02 PM, Rebecca Clarke <r.clarke83 at gmail.com>wrote:

> The data was originally in a MDB as an OLE Object. I used GDAL to import
> the data. (If this is of any use).
>
>
> On Wed, Jul 25, 2012 at 2:59 PM, Rebecca Clarke <r.clarke83 at gmail.com>wrote:
>
>> There is no index on the table.
>>
>> 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
>>
>> 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
>>
>>
>> On Wed, Jul 25, 2012 at 2:54 PM, Sandro Santilli <strk at keybit.net> wrote:
>>
>>> On Wed, Jul 25, 2012 at 02:27:14PM +0100, Rebecca Clarke wrote:
>>> > Your code below works for me also. It's obviously just my data.
>>> >
>>> > the field is data type bytea:
>>> >
>>> > \x010300000000000000
>>>
>>> Looks like HEXWKB to me, for "POLYGON EMPTY".
>>> What makes you think it is "bytea" ?
>>>
>>> > I ran:
>>> >
>>> > select st_astext(the_geom) from tbl where id = 6052
>>> >
>>> > and it returns:  "POLYGON EMPTY"
>>> >
>>> > When I run the st_isvalid on it:
>>> >
>>> > select st_isvalid(the_geom) from tbl where id = 6052
>>> > or
>>> > select st_isvalid(the_geom::geometry) from tbl where id = 6052
>>> >
>>> > It throws the segmentation error.
>>> >
>>> > I just upgrade to postgis 1.5.5 and this made no difference.
>>>
>>> Can you show the output of "SELECT postgis_full_version()"
>>> _and_ the output of "SELECT version()" ?
>>> Is there an index on "tbl" ?
>>>
>>> --strk;
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120725/73103017/attachment.html>