[postgis-users] Assistance with ST_Transform in Ver. 1.5.1 returning projection error

Tom Kessler tom at aktalita.com
Fri Sep 17 08:16:17 PDT 2010


I recently upgraded from Postgis 1.3 to 1.5 and started seeing projection
errors returned from pgsql triggers. I was able to reduce the problem to the
behavior of this simple query:

In 1.3  the following two queries work without error:

Select astext(st_transform
(GeomFromText('POINT( -80 13 )',4326), 32613))

Select astext(st_transform
(GeomFromText('POINT( 80 13 )',4326), 32613))

In 1.5 the first query works and the second one returns a "couldn't project
point - lat or long exceeded limits error."

My 1.3 version is:

POSTGIS="1.3.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct 2006"
USE_STATS

My 1.5 full version is:
POSTGIS="1.5.1" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009"
LIBXML="2.6.32" USE_STATS

proj4text in both spatial_ref_sys SRID entries is identical...Is this
related to need for  grid-shift files?

Thanks in advance.

Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100917/e6202597/attachment.html>


More information about the postgis-users mailing list