[postgis-users] ERROR: Out of memory

[Andreas Laggner]

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


-- 
Dipl. Geoökologe Andreas Laggner
Institut für Ländliche Räume (LR)
Bundesforschungsanstalt für Landwirtschaft (FAL)

Institute of Rural Studies
Federal Agricultural Research Centre (FAL)

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 5515
Fax: (+49) (0)531 596 5599
E-mail: andreas.laggner at fal.de
Homepage: http://www.lr.fal.de/