On Wed, 2007-06-20 at 15:25 +0200, Lobo wrote: > Hi, > > I have problem executing the following query: > > SELECT transform(the_geom,4326) FROM gm_1996; > > It results in the following error message: > > ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=sterea > +lat_0= 52.15616055555555 +lon_0=5.38763888888889 +k=0.999908 > +x_0=155000 +y_0=463000 +ellps=bessel +units=m > +towgs84=565.2369,50.0087,465.658,-0.406857330322398,0.350732676542563,-1.8703473836068,4.0812 > +no_defs': unknown projection id > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. > > Everything else works fine, the data display nicely in uDig and QGIS > and all Postgis functions work, just not the transform function. > > I have added 2671 SRID's to spatial_ref_sys with the > spatial_ref_sys.sql file. And I have registered the table gm_1996 to > the SRID 28992 (RD / New). Both SRID 28992 and 4326 exist in the > spatial_ref_sys table. The same error also comes in trying to > transform to any other registered SRID. > > I am running POSTGIS="1.1.1" GEOS="2.1.4" PROJ="Rel. 4.4.8, 3 May > 2004" USE_STATS ON PostgreSQL 8.0.6 on i686-apple-darwin8.5.1, > compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple > Computer, Inc. build 5250). > > It would be great if you could help me out a little. > > Thanks, > > lobo
Hi Lobo, Several other people have reported a problem with the transform() function, and the common denominator seems to be that they are running on Darwin. Unfortunately I don't have access to an Apple machine, so I need some more information to solve this one. Would you be able to compile a debug build and provide a backtrace from gdb? Kind regards, Mark. -- ILande - Open Source Consultancy http://www.ilande.co.uk _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users