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

[Marco Vieira]

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?

Marco Vieira.
Fone:    + 55 21 9499-6800
marco_vieira at uk2.net