[postgis-tickets] [PostGIS] #2366: Cancelling query with ST_Union crashes PostgreSQL server
PostGIS
trac at osgeo.org
Thu Jun 20 06:54:35 PDT 2013
#2366: Cancelling query with ST_Union crashes PostgreSQL server
---------------------+------------------------------------------------------
Reporter: dbaston | Owner: pramsey
Type: defect | Status: new
Priority: high | Milestone: PostGIS 2.1.0
Component: postgis | Version: 2.0.x
Keywords: |
---------------------+------------------------------------------------------
When I cancel a query with ST_Union after realizing that it will take a
long time, my Windows PostgreSQL server crashes.
"POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March
2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"
"PostgreSQL 9.2.1, compiled by Visual C++ build 1600, 64-bit"
An example query is something like
SELECT city, ST_Union(geom) FROM cities GROUP BY city
Geometries in the table are multipolygons.
Please let me know if there is more useful information that I can provide.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2366>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list