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

[Andrew Joseph]

spatial ref sys entries are identical

2.4.1

+proj=lcc +lat_1=31.88333333333333 +lat_2=30.11666666666667
+lat_0=29.66666666666667 +lon_0=-100.3333333333333 +x_0=699999.9998983998
+y_0=3000000 +datum=NAD83 +units=us-ft +no_defs 

2.3.2

+proj=lcc +lat_1=31.88333333333333 +lat_2=30.11666666666667
+lat_0=29.66666666666667 +lon_0=-100.3333333333333 +x_0=699999.9998983998
+y_0=3000000 +datum=NAD83 +units=us-ft +no_defs 

The error only occurs when running st_transform() on foreign tables, and
does not occur on concrete tables. Is the function AddToPROJ4SRSCache
something that would be pushed down by ogr_fdw to GDAL?

Here is the full set of commands that produced the failure, run directly on
a fresh install / database:

DROP SERVER IF EXISTS shapefiles CASCADE;
CREATE SERVER shapefiles
  FOREIGN DATA WRAPPER ogr_fdw
  OPTIONS (
    datasource '/data/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_transform(geom,4326)

FROM

    shapefiles.testshp



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