[postgis-users] GeomUnion() crashes backend?
strk at refractions.net
strk at refractions.net
Mon Nov 28 07:34:40 PST 2005
I can reproduce the bug on Postgis-HEAD, PGSQL800.
accum(pgpoly) is enough, so it's not GEOS-related.
One geometry is NULL, and that's the problem.
Tested on PGSQL7.3.4 everything works, so NULL
handling must have changed between PGSQL versions ..
I'm checking this.
--strk;
On Mon, Nov 28, 2005 at 03:11:41PM +0100, Hubert Fröhlich wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
--
/"\ ASCII Ribbon Campaign
\ / Respect for open standards
X No HTML/RTF in email
/ \ No M$ Word docs in email
More information about the postgis-users
mailing list