Regina Obe

osm2pgrouting compile instructions needs updating for cmake flags

1

Now that @sanak put in the changes for postgres install. I notice I have to add: `-DPOSTGRESQL_INCLUDE_DIR:PATH=${PGPATH}/include` To my cmake call. This is good since it does allow me to...

I don't recall getting these warnings last time I compiled www_fdw, but I might have. The dlls compile and load and seem to work, so not sure if I should...

Querying information_schema.tables.is_insertable_into with vsizip datasource errors

2

``` CREATE EXTENSION ogr_fdw; CREATE SCHEMA staging; DROP SERVER IF EXISTS fds_ne CASCADE; CREATE SERVER fds_ne FOREIGN DATA WRAPPER ogr_fdw OPTIONS(datasource '/vsizip//vsicurl/http://postgis.us/downloads/ne_10m_admin_1_states_provinces.zip', format 'ESRI Shapefile'); IMPORT FOREIGN SCHEMA ogr_all FROM...

osm INTERLEAVED_READING how to specify or can it be

1

I was trying to link this file using ogr_fdw and got slapped with the turn on INTERLEAVE notice. https://download.geofabrik.de/europe/belarus-latest.osm.pbf I tried this: ``` CREATE SERVER svr_osm FOREIGN DATA WRAPPER ogr_fdw...

Can't import a file with a field called fid

2

I assume this is the case for all files, but I tried reimporting an excel spreadsheet I had exported from an imported table and was greeted with this message: `IMPORT...

Ability to rename the fid column

10

If this isn't possible, then ogr_fdw should at least throw an error telling you that. Here is my situation. I have this SQLite database with primary keys and GDAL has...

PG 16 regression failures on 3.6

1

**Problem** When testing PG 16 under mingw64 against main branch, 2 tests fails **Failures** ``` ../../pgtap/withPoints/withPointsDD/edge_cases/issue_979.pg (Wstat: 0 Tests: 6 Failed: 1) Failed test: 3 Files=479, Tests=53713, 378 wallclock secs...

- Fix compile PostgreSQL 17 - Add pg17 to CI Closes #255

PG17 compile error and add PG17 ci

1

I was gearing to add a PG17 cause well stuff is breaking in postgis, so figure stuff might be breaking here too and voila, we have an issue https://github.com/robe2/pgsql-ogr-fdw/actions/runs/8444294542/job/23129550923 ```...

Option to rename duplicated columns

2

I haven't looked to see how hard this is. Every once in a while someone has the bad sense to give me a spreadsheet with duplicated columns. Where they'll have...