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

[Rémi Cura]

most likely you havn't !
I don't know your os so answering is difficult.

If you have the size of fb free on list,
you can try a
VACUUM FULL ANALYZE

then try again =)
Other wise, you may have to do you computing piece by piece.

Cheers,
Rémi-C


2013/12/19 <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.
>
>
> --
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131219/688f69a6/attachment.html>