[postgis-users] transform problem

[Mark Cave-Ayland]

On Mon, 2007-04-16 at 11:00 +0200, bange at argoss.nl wrote:
> I cannot get the Transform function working on Mac OSX. When I try  
> something like
> 
> select transform(geomfromtext('MULTIPOLYGON(((45340.81  
> 387680.7,51892.99 387641.0, 52012.12 380810.8,45459.94  
> 380850.5,45340.81 387680.7)))',28992),3395)
> 
> I get a query that is running for some time, and the result is a ':'  
> and 'lost connection to server'. Anybody got the same problem ?
> 
> I am running postrgesql 8.1.5, postgis 1.1.6 proj 4.4.8.
> 
> Thanks, Peter Bange


Hi Peter,

Are there any messages in the PostgreSQL server log? I get the following
output from psql here:

postgis=# select transform(geomfromtext('MULTIPOLYGON(((45340.81
postgis'# 387680.7,51892.99 387641.0, 52012.12 380810.8,45459.94
postgis'# 380850.5,45340.81 387680.7)))',28992),3395);
ERROR:  AddToPROJ4SRSCache: Cannot find SRID (3395) in spatial_ref_sys
postgis=# select * from spatial_ref_sys where srid = 3395;
 srid | auth_name | auth_srid | srtext | proj4text
------+-----------+-----------+--------+-----------
(0 rows)

postgis=# select postgis_full_version();
                   postgis_full_version
----------------------------------------------------------
 POSTGIS="1.1.6" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS
(1 row)
postgis=# select version();
                                                  version 
------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.1.8 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt
(GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
(1 row)


Also, a good check would be to see if the reprojection works for any
other SRID values...


Kind regards,

Mark.