[postgis-users] Signal 11: Segmentation fault

Sandro Santilli strk at keybit.net
Wed Jul 25 06:54:22 PDT 2012


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;



More information about the postgis-users mailing list