[postgis-users] Error database geometry requires more points - postgis 1.5

[Maria Eugenia Calle Peralta]

Hi Mike:

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).

Thanks.

Maria Eugenia

> From: mwtoews at gmail.com
> Date: Wed, 4 Jun 2014 14:26:04 +1200
> To: postgis-users at lists.osgeo.org
> Subject: Re: [postgis-users] Error database geometry requires more points - postgis 1.5
> 
> Hi Maria,
> 
> What version do you have?
> SELECT PostGIS_Full_Version();
> 
> There are a few bugs for "geometry requires more points". How did you
> ST_NumPoints() on a MultiLineString type? Is there a constraint for
> the geometry type?
> 
> -Mike
> 
> On 4 June 2014 13:32, Maria Eugenia Calle Peralta <maugecp at hotmail.com> wrote:
> > Hi:
> >
> > We are working a database with postgis 1.5. (postgresql 9.1).  Around 30
> > users editing a hidrography table (multilinestring) together at the same
> > time using quantum gis. The last days we had a problem, when viewing the
> > layer at certain zoom objects disappear and the error is reported "Error
> > database geometry requires more points".
> >
> > I check with the functions:
> >
> >
> > -ST_isvalid(), Geometry invalid not found.
> >
> > -ST_NumPoints(), All geometries have more than 2 vertex
> >
> >
> > The reference system is defined and even add a constraint
> > verify_geometry_valid CHECK (st_isvalid(geom)) and the problem remains.
> > I dont kown where is the problem.
> >
> >
> > Thank you much help.
> >
> >
> > Maria Eugenia
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140604/f42fa8d1/attachment.html>