[postgis-users] crash on ST_Clip()

[Paul Ramsey]

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