[postgis-users] [XX000] ERROR: AddToPROJ4SRSCache: could not parse proj4 string

[Andrew Joseph]

Slight Correction: I actually get an error on 4326 and NOT 2277 when running
the following commands in a single transaction block:

DROP SERVER IF EXISTS shapefiles CASCADE;
CREATE SERVER shapefiles
  FOREIGN DATA WRAPPER ogr_fdw
  OPTIONS (
    datasource 'testshp.shp',
    format 'ESRI Shapefile'
  );
DROP SCHEMA IF EXISTS shapefiles CASCADE;
CREATE SCHEMA shapefiles;

CREATE FOREIGN TABLE shapefiles.testshp(
  fid bigint,
  pid_10 text,
  prop_id text,
  geom geometry(MultiPolygon,2277)
) SERVER shapefiles OPTIONS (layer 'testshp');
SELECT ST_AsText(ST_Transform(ST_Transform(ST_SetSRID(ST_Point(-97.353287,
31.105862), 4326), 2277),4326));

yields:

ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+proj=longlat
+datum=WGS84 +no_defs ' unknown elliptical parameter name
SQL state: XX000

So it definitely isn't an issue of missing nad files.



--
Sent from: http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html