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

[Lobo]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070620/ea9c7a02/attachment.html>