<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi Mike:<br><br>Well, the version is "POSTGIS="1.5.3" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS" and yes, the table had a constraint: CHECK (geometrytype(geom) = 'MULTILINESTRING'::text OR geom IS NULL).<br><br>Thanks.<br><br>Maria Eugenia<br><br><div>> From: mwtoews@gmail.com<br>> Date: Wed, 4 Jun 2014 14:26:04 +1200<br>> To: postgis-users@lists.osgeo.org<br>> Subject: Re: [postgis-users] Error database geometry requires more points - postgis 1.5<br>> <br>> Hi Maria,<br>> <br>> What version do you have?<br>> SELECT PostGIS_Full_Version();<br>> <br>> There are a few bugs for "geometry requires more points". How did you<br>> ST_NumPoints() on a MultiLineString type? Is there a constraint for<br>> the geometry type?<br>> <br>> -Mike<br>> <br>> On 4 June 2014 13:32, Maria Eugenia Calle Peralta <maugecp@hotmail.com> wrote:<br>> > Hi:<br>> ><br>> > We are working a database with postgis 1.5. (postgresql 9.1). Around 30<br>> > users editing a hidrography table (multilinestring) together at the same<br>> > time using quantum gis. The last days we had a problem, when viewing the<br>> > layer at certain zoom objects disappear and the error is reported "Error<br>> > database geometry requires more points".<br>> ><br>> > I check with the functions:<br>> ><br>> ><br>> > -ST_isvalid(), Geometry invalid not found.<br>> ><br>> > -ST_NumPoints(), All geometries have more than 2 vertex<br>> ><br>> ><br>> > The reference system is defined and even add a constraint<br>> > verify_geometry_valid CHECK (st_isvalid(geom)) and the problem remains.<br>> > I dont kown where is the problem.<br>> ><br>> ><br>> > Thank you much help.<br>> ><br>> ><br>> > Maria Eugenia<br>> ><br>> > _______________________________________________<br>> > postgis-users mailing list<br>> > postgis-users@lists.osgeo.org<br>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@lists.osgeo.org<br>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></div> </div></body>
</html>