[postgis-tickets] [PostGIS] #4612: No WFS support for OGR FDW under Windows

[PostGIS]

#4612: No WFS support for OGR FDW under Windows
------------------------------------+----------------------------------
  Reporter:  davis                  |      Owner:  robe
      Type:  defect                 |     Status:  new
  Priority:  high                   |  Milestone:  PostGIS 3.0.1
 Component:  build/upgrade/install  |    Version:  3.0.x
Resolution:                         |   Keywords:  wfs, ogr fdw windows
------------------------------------+----------------------------------

Comment (by robe):

 Can you replace your gdal-20.dll in your C:/Program
 Files/PostgreSQL/12/bin folder with the one in this zip

 https://winnie.postgis.net/download/windows/pg12/buildbot/extras/gdal_2.4.3
 -with-curl.zip


 LONG ANSWER AS TO THE ISSUE

 I haven't repackaged the ogr_fdw with this cause I'm still having issue
 when doing this:

 -- the unsafessl is so it doesn't bother checking ssl cert, so I don't
 have to set that as env

 CREATE SERVER geoserver
                 FOREIGN DATA WRAPPER ogr_fdw
                 OPTIONS (
 datasource 'WFS:https://demo.geo-solutions.it/geoserver/wfs',
 format 'WFS', config_options 'GDAL_HTTP_UNSAFESSL=yes' );


 But it recognizes the curl now but is giving an EPSG error


 {{{
 ERROR:  GDAL NotSupported [6] EPSG PCS/GCS code 404000 not found in EPSG
 support files.  Is this a valid EPSG coordinate system?
 SQL state: XX000
 }}}

 So I think that's an unrelated issue.  I tried with my state government
 (which I know used to work eons ago when I tested)

 WFS:https://giswebservices.massgis.state.ma.us/geoserver/wfs?service=WFS&version=1.0.0

 and get the same error with same specific complaint about this particular
 EPSG

 I looked in the pcs.csv file in C:/Program Files/PostgreSQL/12/gdal-
 data/pcs.csv and can't find this code listed there.  So not sure if maybe
 its a new GeoServer one or something different with GDAL. Both sites use
 geoserver.

 At anyrate the other issue I need to troubleshoot is for some reason GDAL
 wasn't picking up the new curl.  I had originally compiled against curl -
 7.67.0, but while GDAL recognized it kinda rejected it with not being able
 to find curl_global_init or some such thing so therefore did not include
 WFS/WMS any curl driver dependent etc support.  So I had to revise to
 compile against curl 7.54.1 which is what I had used previously.  So I'm
 checking to see whether it's an issue in my curl build or something about
 GDAL not handling newer curl.

 But at anyrate -- it seemed to load fine using the new curl (which is what
 is shipped with the PostGIS 3.0 bundle)

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4612#comment:6>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.