[postgis-devel] [PostGIS] #387: ST_Transform decimal issue on Win32

[PostGIS]

#387: ST_Transform decimal issue on Win32
-----------------------+----------------------------------------------------
  Reporter:  colivier  |       Owner:  pramsey                   
      Type:  defect    |      Status:  new                       
  Priority:  medium    |   Milestone:                            
 Component:  postgis   |     Version:  trunk                     
Resolution:            |    Keywords:  ST_Transform Win32 decimal
-----------------------+----------------------------------------------------
Comment (by robe):

 I think its a problem with our packaging because I can reproduce it on our
 end.  Something must have changed with where SetProj4LibPath() is lookin
 in 1.4 install for windows.  Mark can you check that?

 We have two databases on the same PostgreSQL service one is running 1.3.6
 and one is running 1.4.1.  the 1.3.6 is producing the stated Linux
 results, but 1.4.1 is not.

 {{{
 SELECT
 ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=28992;LINESTRING(121197.452
 483388.474 0 ,121194.232643364 483391.530431554 0)'),4326));


 "SRID=4326;LINESTRING(4.8912328883848 52.3373804295345
 43.0455399095536,4.89118534688269 52.3374077007853 43.0454913372059)" --
 1.3.6


 "SRID=4326;LINESTRING(4.89159420399379 52.3383892154259 0,4.89154665531731
 52.338416489781 0)"  -- 1.4.1
 }}}


 I had assumed both would be looking in the same location for proj.  We
 never really fussed with that.

 Paul - I disagree with changing the proj location to be versioned.  The
 reason is that on the same postgresql install, both will be using the same
 proj.dll anyway so they should be using the same datum shift files as
 well.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/387#comment:6>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.