[postgis-users] Collect problem

Daniel daniel.faivre at camptocamp.com
Tue May 2 02:46:02 PDT 2006


Hello,

I've used to proceed queries like:
SELECT collect(lga_geom) as buffer FROM lg_annee
WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 GROUP BY lga_annee;

With last versions of Postgis, such queries failed, even if I add tests 
like:

SELECT collect(lga_geom) as buffer FROM lg_annee
WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 and lga_geom is 
not null
and isvalid(lga_geom) and dimension(lga_geom)=2 GROUP BY lga_annee;

Errors reported are:

NOTICE:  Self-intersection
[....]
NOTICE:  Self-intersection
NOTICE:  Self-intersection

ERROR:  lwcollection_construct: mixed dimension geometries

Table lg_annee contain 2-dimension polygon geometries. The query worked 
fine with older versions.

What can I do ?

Any idea ?

dF

-------------- next part --------------
A non-text attachment was scrubbed...
Name: daniel.faivre.vcf
Type: text/x-vcard
Size: 323 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060502/0018b49e/attachment.vcf>


More information about the postgis-users mailing list