[postgis-users] GEOS union() error

[Obe, Regina]

Well I've never seen that particular error before.  Usually if I need to
bump up memsize, it explicitly says its "OUT OF MEMORY"

The specific error sounds like its trying to write to a non-existent
address space or space already in use.  Not quite sure what would cause
that.

Does it work if you limit your buffering to something like below?

SELECT buffer(collect(the_geom), 400) as the_geom  
FROM (SELECT the_geom from main limit 10) As newmain 

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Lee
Keel
Sent: Wednesday, November 07, 2007 9:47 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] GEOS union() error

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Obe, Regina
> Sent: Wednesday, November 07, 2007 8:41 AM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] GEOS union() error
> 
> >From my experience it always returns a multipolygon giving a geometry
> collection of multipolygons.
> 
> Actually collect doesn't always return geometry collections anyway.
If
> you say collect a bunch of polygons and they are not overlapping, then
> from my experience that returns a multipolygon.  If you start with
> multipolygons,then it returns a geometry collection, but if you then
> buffer that geometry collection, its seems to result in a multipolygon
> for me - never had it return a geometry collection.  I think its
> something about the process of buffering that strips out the
geometries
> from the geometry collection - since if you feed it a single polygon
> encased in a multipolygon structure, it returns a polygon.
> 
> I don't know too much of the details of why that is.
> 
> Thanks,
> Regina
> 
> 
[Lee Keel] 


Well the good news is that actually returned in a very reasonable
time...
Bad news is that I got an error:


NOTICE:  St9bad_alloc

ERROR: GEOS buffer() threw an error!
SQL state: XX000


Could this be that my work_mem should be set higher?

-LK
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
sender. This message contains confidential information and is intended
only for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.