SELECT ST_AsText(ST_Transform(ST_Transform(ST_SetSRID(ST_Point(-97.353287, 31.105862), 4326), 2277),4326));
produces "POINT(-97.353287 31.1058619999995)" - so it appears to work The table srid for both concerete and foreign tables shows as 2277. Using st_transform(st_setsrid(geom,2277),4326) on the foreign table fails as well. I've tried reverting my configuration back as far as possible (2.3.2 breaks on postgres 10+): "POSTGIS="2.3.4 r16009" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.3.0" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.0, released 2017/04/28" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER" This leads me to believe that either something is wrong with my PROJ configuration, as Paul suggested, or that something has been fundamentally broken between proj4.8 and proj4.9. Should I be able to rely on the standard Ubuntu 16.04 PROJ libraries? I've built 4.9.3 from source and also tried using standard packages: apt-get install libproj9 libproj-dev proj-data proj-bin Both installations result in the same issue. Am I missing a critical package, or is there environment variable that needs to be set for PROJ to work properly with postgis? -- Sent from: http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
