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
