[postgis-users] Transform Error results in connection with PostgreSQL server closed

[Mark Cave-Ayland]

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