[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Error database geometry requires more points - postgis 1.5
From: Maria Eugenia Calle Peralta <maugecp () hotmail ! com>
Date: 2014-06-04 15:25:52
Message-ID: COL126-W267D365B25C33544F5BD12A7220 () phx ! gbl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@gmail.com
> Date: Wed, 4 Jun 2014 14:26:04 +1200
> To: postgis-users@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@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@lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<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>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic