[postgis-users] ST_Union() about 1179 raster-tiles cause ProgreSQL crashes

[Jackie]

Ngày 2014-03-18 9:22 AM, Mike Toews vie^'t:
> On 18 March 2014 15:15, Jackie <justaniceguy.nguyen at gmail.com> wrote:
>> Here's my polygon:
>> ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 105.78873
>> 20.71758, 106.49185 20.71758, 105.78873 21.38659))', 4326)
> This polygon is an invalid bow-tie, with a self-intersection in the centre.
>
> -Mike
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Hi Mike,
It's my mistake. I swapped point No. 3 and point No. 4 and now the 
message is "out of memory"
Besides, I can get the result with one band, but when I try to merge 3 
bands, it fails.

ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 
106.49185 20.71758, 105.78873 20.71758, 105.78873 21.38659))', 4326)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140318/7be0c0bf/attachment.html>