[postgis-users] ERROR: Out of memory

[Kevin Neufeld]

What happens if you use ST_MemUnion(...) instead?

-- Kevin

Andreas Laggner wrote:
> Hi,
>
> i tried to perform the "union approach" from Kevin 
> http://postgis.refractions.net/support/wiki/index.php?ExamplesOverlayTables 
>
> the first query worked fine:
> CREATE TABLE all_lines AS
>   SELECT St_ExteriorRing (the_geom) AS the_geom FROM ffhsinglerep
>   UNION ALL
>   SELECT St_ExteriorRing (the_geom) AS the_geom FROM spasinglerep;
>
> but in the second one i get an error:
> CREATE TABLE noded_lines AS
>   SELECT St_Union(the_geom) AS the_geom
>   FROM all_lines;
>
> ERROR: Out of memory
> SQL Status:53200
> Detail:Failed on request of size 20750552.
>
> If anybody knows what may be behind this error......i have no idea!
>
> Cheers      Andreas
>
>