[postgis-users] GeomUnion() crashes backend?

[Hubert Fröhlich]

Hi list,

I am using Postgres on Linux boxes (SuSE 9.3 and 10.2); I use

PostgreSQL 8.0.3, Geos 2.1.2, Postgis 1.0.2 combination on several HP 
ProLiant ( Xeon and also Opteron) servers
PostgreSQL 8.1.0, Geos 2.1.4, Postgis 1.0.4 combination on a pentium4 
desktop.

I am doing Postgis GeomUnion() on 3 polygons; 2 of them are relatively 
large (npoints> 500), one of them is NULL (dont ask me why this is NULL!) .

The dump is enclosed. (does the attachment get through the firewall? if 
not, i can mail separately).

When I try
testpoly=# select geomunion(pgpoly) from testpoly2;
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

I get a backend crash.

What has happened?



I am
-- 
Mit freundlichen Grüßen / With kind regards

Hubert Fröhlich

-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Landesamt für Vermessung und Geoinformation
Alexandrastr. 4, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2129 - 2980
Fax  :+49 (0)89 / 2129 - 2997
hubert dot froehlich at lvg dot bayern dot de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: testpoly2.sql
Type: text/x-sql
Size: 42821 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051128/34a60191/attachment.bin>