[postgis-devel] possible Bug in PG 2.1 ( ST_AsX3d() on TIN) ?

[Sandro Santilli]

On Fri, Oct 25, 2013 at 02:03:56PM +0200, Till Adams wrote:
> Hi,
> 
> we want to create a X3d file from a point cloud. Therefore we create
> a TIN (you may get this from here:
> http://www.webmapcenter.de/downloads/ewkt.tin.zip)
> 
> The output was created by ST_ASEWKT, which works fine!
> 
> My environment:
> POSTGIS="2.1.0 r11822" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel.
> 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12/29"
> LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER
> 
> 
> What we did: Created a geometry collection from a point cloud
> (approx 120k values), then used the ST_DelaunayTriangles function.
> Afterwards we wanted to get out this as a x3d-file. When we do this
> on the same data and limit the no. of used points to 50k everything
> works fine).
> 
> When doing this on the whole data, we get this error:
> ( st_asx3d([data from zip-file above]) )
> 
> ERROR:  invalid memory alloc request size 2783188712

I don't know much about X3D but can you maybe combine multiple
records from chunks of elements of the collection ?

ST_AsX3D(geom) from ( select (ST_Dump(returnFromDelaunay)).geom ) as x

--strk;