[postgis-users] Crash with PostGIS transform()
uli mueller
uli.mueller at gmx.ch
Thu Mar 8 02:29:20 PST 2007
Installing the newest proj.4.5 solved the problem.
Uli
uli mueller wrote:
> Hi all
>
> My PostGIS crashes when calling transform() for two different datums.
>
> The following runs fine:
> select transform(geometryfromtext('POINT(9 47)',4326),32632); (32632 is
> UTM Zone 32 with WGS 84)
>
> This one (and other srids) crashes: select
> transform(geometryfromtext('POINT(9 47)',4326),31462);
>
> SRID=31462 has the following definition in our spatial_ref_sys:
> 31462 | EPSG | 31462 | PROJCS["DHDN / 3-degree Gauss zone
> 2",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel
> 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",6],PARAMETER["scale_factor",1],PARAMETER["false_easting",2500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","31462"]]
> | +proj=tmerc +lat_0=0 +lon_0=6 +k=1.000000 +x_0=2500000 +y_0=0
> +ellps=bessel +datum=potsdam +units=m +no_defs
>
>
> I also tried upgrading from Postgis 1.1.3 to 1.1.7 but the crash happens
> with both versions.
>
> The system is 64bit Suse 9.1. I have more or less the same
> PostGIS/GEOS/Proj-installation on a 32bit Suse 10.1 where I do not have
> any problems. The contents of spatial_ref_sys are identical on both
> systems.
>
> Any help greatly appreciated!
>
> Uli
>
--
geOps GeoInformatics
D-79100 Freiburg
More information about the postgis-users
mailing list