[postgis-users] help with the Union of 2 shp

[islanis at infomed.sld.cu]

ok i execute this:
//------------------------------------
DROP TABLE IF EXISTS SPLITED;
CREATE TABLE SPLITED AS
SELECT ST_Split(b.the_geom,z.the_geom) AS the_geom
FROM public.mapa_base_141213 b, public.all_lines_merged z;
UPDATE SPLITED SET the_geom = ST_SetSRID(the_geom,4326);
SELECT Populate_Geometry_Columns('public.SPLITED'::regclass);
ALTER TABLE SPLITED ADD column gid serial;
ALTER TABLE SPLITED ADD COLUMN dato character varying;
ALTER TABLE SPLITED ADD PRIMARY KEY (gid);


DROP TABLE IF EXISTS collectionExtracted;
CREATE TABLE collectionExtracted AS
SELECT ST_CollectionExtract(b.the_geom,3) AS the_geom
FROM public.SPLITED b;
UPDATE SPLITED SET the_geom = ST_SetSRID(the_geom,4326);
SELECT Populate_Geometry_Columns('public.collectionExtracted'::regclass);
ALTER TABLE collectionExtracted ADD column gid serial;
ALTER TABLE collectionExtracted ADD COLUMN dato character varying;
ALTER TABLE collectionExtracted ADD PRIMARY KEY (gid);


DROP TABLE IF EXISTS dumped;
CREATE TABLE dumped AS
SELECT (ST_Dump(b.the_geom)).geom AS the_geom
FROM public.rad_solar_directa b;
UPDATE dumped SET the_geom = ST_SetSRID(the_geom,4326);
SELECT Populate_Geometry_Columns('public.dumped'::regclass);
ALTER TABLE dumped ADD column gid serial;
ALTER TABLE dumped ADD COLUMN dato character varying;
ALTER TABLE dumped ADD PRIMARY KEY (gid);
///-------------------------------------------------------
and i get this error
//---------------------------------
ERROR:  no se pudo extender el archivo «base/604204/609808.5»: No  
space left on device
HINT:  Verifique el espacio libre en disco.

********** Error **********

ERROR: no se pudo extender el archivo «base/604204/609808.5»: No space  
left on device
Estado SQL:53100
Sugerencias:Verifique el espacio libre en disco.

//--------------------------------------------------------
and i have 11,5Gb of free space what can i do to solve this problem now.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


--

Este mensaje le ha llegado mediante el servicio de correo electronico que ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema Nacional de Salud. La persona que envia este correo asume el compromiso de usar el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/


-------------- next part --------------
An embedded message was scrubbed...
From: islanis at infomed.sld.cu
Subject: Re: [postgis-users] help with the Union of 2 shp
Date: Thu, 12 Dec 2013 13:21:00 -0500
Size: 15572
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131219/f4c49767/attachment.mht>