[postgis-devel] A postgres crash with alpha6

aperi2007 aperi2007 at gmail.com
Sat Feb 25 03:43:11 PST 2012


Hi,

I resolve the quest.
Really was a wrong query I mismatch the

 >    ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry

with

 >    ST_Multi(ST_Union(b.geom))::geometry(MULTIPOLYGON,3003) as geometry

the a.geom was ahuge geometry with many thousand vertexs so the postgres 
gone in out of memory.

changing to
 >    ST_Multi(ST_Union(b.geom))::geometry(MULTIPOLYGON,3003) as geometry

all work ok.

I really was too tired.

Sorry for noise.

Andrea.


 >Hi,
 >Uisng the alpha6 release for windows and try-ing this query:
 >....
 >select
 >    1 as id,
 >    a.nome,
 >    'DBTopografico RT da Ristrutturazione Multiscala - selezione
 >provinciale'::text as titolo,
 >    '13-02-2012'::text as data_estrazione,
 >    ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry
 >from
 >    tematici.am_prov_region_am_prov as a,
 >    gb.porzioneterritoriorestituito as b



More information about the postgis-devel mailing list