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: [email protected] > Date: Wed, 4 Jun 2014 14:26:04 +1200 > To: [email protected] > 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 <[email protected]> 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 > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
