[postgis-users] crash on ST_Clip()

[Stephen Crawford]

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<src176 at 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
>> src176 at psu.edu
>> 814.865.9905
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
src176 at psu.edu
814.865.9905