Bryan, Not sure if you got the cc to the bug report I posted.
The issue seems to be that the: http://spatialreference.org/ref/iau2000/49910/ Is lacking a proj4text -- PostGIS pretty much ignores everything in the spatial_ref_sys except the proj4text column. The rest of it is just metadata for other tools. So you need to figure out the comparable proj4text for this -- assuming there is one. It is a bug though that PostGIS even allows entries into the spatial_ref_sys without coughing an error when proj4text is empty. Thanks, Regina http://www.postgis.us > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Bryan Hempen > Sent: Saturday, July 30, 2011 6:17 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] st_transform crashes > > @Leo and Regina: > > "POSTGIS="2.0.0SVN" GEOS="3.3.1dev-CAPI-1.7.1" PROJ="Rel. 4.6.1, 21 August > 2008" LIBXML="2.7.8" USE_STATS" > > "PostgreSQL 8.4.8, compiled by Visual C++ build 1400, 32-bit" > > I am using Windows XP. > > > > @Josh Jordan: > > I had some invalid geometries in the table but fixed them now. > > select count(*) from alldata where ST_IsValid(the_geom) = 'f'; > > returns 0. However, the database still crashes. > > > > Thanks for the input so far. Any other ideas? > > Kind regards, > Bryan > > > > _______________________________________________ > 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
