[postgis-users] isvalid(the_geom) crash my db

[strk at refractions.net]

On Thu, Sep 29, 2005 at 08:16:39PM -0300, Marco Vieira wrote:
> Hi all.
>   My db crash when I do select *,isvalid(the_geom) from foo limit 1;
> 
>   foo is created by shp2pgsql with only -s 4291 option (second time I
> tried -w option with same result).
> 
> foo have:
> (
>   gid serial NOT NULL,
> (...)
>   the_geom geometry,
>   CONSTRAINT ba_se_pkey PRIMARY KEY (gid),
>   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
>   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
> 'MULTIPOLYGON'::text OR the_geom IS NULL),
>   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4291)
> )
> WITH OIDS;
> 
>    The message log is:
> "server closed the connection unexpectedly
> This probably means the server terminated abnormally before or while
> processing the request."
> 
>    My postgis_full_version() is: POSTGIS="1.0.0" GEOS="2.1.4" PROJ="Rel.
> 4.4.9, 29 Oct 2004" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
> 
>    On debian kernel 2.6.8-2-386.
> 
>   Other queries such as select *,area(the_geo) from foo can be done.
> 
> Any clue?

Could you provide the_geom value ?
	SELECT the_geom from foo limit 1;
So we can test against new (and same) version...

--strk;