Re: [gdal-dev] Problem appending non-geometry tables in PostGis

2015-06-05 Thread Even Rouault
Le vendredi 05 juin 2015 02:19:06, Roger André a écrit : Hi All, I'm having some trouble using ogr2ogr to do batch uploads to a Postgis DB. It appears that on tables which don't contain geometry, CreateLayer is failing and not allowing data to be appended to an existing table. Here is the

Re: [gdal-dev] Problem appending non-geometry tables in PostGis

2015-06-05 Thread Roger André
Even, That works, thanks. Roger On Fri, Jun 5, 2015 at 12:52 AM, Even Rouault even.roua...@spatialys.com wrote: Le vendredi 05 juin 2015 02:19:06, Roger André a écrit : Hi All, I'm having some trouble using ogr2ogr to do batch uploads to a Postgis DB. It appears that on tables which

[gdal-dev] Problem appending non-geometry tables in PostGis

2015-06-04 Thread Roger André
Hi All, I'm having some trouble using ogr2ogr to do batch uploads to a Postgis DB. It appears that on tables which don't contain geometry, CreateLayer is failing and not allowing data to be appended to an existing table. Here is the command that is being used to load each feature class: ogr2ogr

Re: [gdal-dev] Problem appending non-geometry tables in PostGis

2015-06-04 Thread Saulteau Don
If you add -nlt NONE to the ogr2ogr command, does that work? You might need to do that just for the non-spatial tables, because if you do that with the spatial tables, they will only upload the attributes. Donovan On Thu, Jun 4, 2015 at 5:19 PM, Roger André ran...@gmail.com wrote: Hi All,