[postgis-users] GeomUnion() crashes backend?
Hubert Fröhlich
hubert.froehlich at lvg.bayern.de
Mon Nov 28 06:11:41 PST 2005
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>
More information about the postgis-users
mailing list