Well I tried the same query for just one of the tiles that I know
intersects the the_geom but it crashed. Then i simplified it further by
using just a box instead of a multipolygon and it still crashed.
On 4/25/2012 3:22 PM, Paul Ramsey wrote:
Find the exact geometry pair that is causing the crash and file a
ticket. (Yes, disconnecting means the backend went boom, that's a
crash).
P
On Wed, Apr 25, 2012 at 12:15 PM, Stephen Crawford<src...@psu.edu> wrote:
All,
I have a query which works on my desktop Windows (postgis2.0 RC) but crashes
on Linux (postgis2.0 official release). And by crash i mean disconnects me
from the server.
INSERT INTO result_raster_table (observation_date, rast)
SELECT r.observation_date, ST_Clip(r.rast,g.the_geom,-9999) AS rast
FROM raster_table r, geom_table g
WHERE r.observation_date = '2012-03-09';
'raster_table ' holds tiles, 187 of which make up one observation_date, and
'geom_table' is just one record, the union of ~23 Eastern US states.
Any thoughts?
Thanks,
Steve
--
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
src...@psu.edu
814.865.9905
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
src...@psu.edu
814.865.9905
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
