[postgis-devel] [PostGIS] #387: ST_Transform decimal issue on Win32
PostGIS
trac at osgeo.org
Mon Jan 18 10:53:54 PST 2010
#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.
More information about the postgis-devel
mailing list