[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] adding additional points to multipoint
From: Christo Du Preez <christo () mecola ! com>
Date: 2006-03-31 13:31:59
Message-ID: 442D2F4F.8020105 () mecola ! com
[Download RAW message or body]
The result is: "MULTIPOINT(1 1,2 2,3 3)"
The version is: "POSTGIS="1.1.1" GEOS="2.2.1-CAPI-1.0.1" PROJ="Rel.
4.4.9, 29 Oct 2004" USE_STATS"
Markus Schaber wrote:
> Hi, Christo,
>
> Christo Du Preez wrote:
>
>> Thank you,
>>
>> When trying
>> update meclabel
>> set the_geom = geomunion(the_geom, GeomFromText('POINT(23 4)', -1))
>>
>> I get:: ERROR: new row for relation "meclabel" violates check
>> constraint "enforce_geotype_the_geom"
>>
>
> Hmm, I did not cast it in my tests, but I guess that, depending on your
> PostGIS version, Geomunion might return a GeometryCollection instead of
> an MultiPoint.
>
> Can you see what PostGIS version you have?
>
> Can you execute
>
> select asText(geomunion('MULTIPOINT(1 1,3 3)',
> geomFromText('POINT(2 2)',-1)));
>
> and tell us its output?
>
>
>
>> CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
>> 'MULTIPOINT'::text OR the_geom IS NULL),
>>
>
> This is the "guilty" constraint that blocks all non-multipoint
> geometries from being inserted into the table.
>
> Markus
>
--
Kind Regards,
Christo Du Preez
Senior Software Engineer
Mecola IT
http://www.mecola.com
+27 [0]83 326 8087
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic