[gdal-dev] I can't get ogr2ogr to overwrite an existing table

[Stephen Woodbridge]

On 4/8/2017 12:29 PM, Even Rouault wrote:
> On vendredi 7 avril 2017 15:59:49 CEST Stephen Woodbridge wrote:
> 
>  > Hi all,
> 
>  >
> 
>  > I'm having trouble figuring out how to overwrite an existing table with
> 
>  > ogr2ogr. I have tried various combos of arguments without success.
> 
>  >
> 
>  > What am I doing wrong?
> 
> I'm not sure. Similar requests work for me with GDAL 2.1. Maybe try to 
> manually drop the table (if it is a table...)
> 
> Seeing the 'CREATE TABLE "census"."roads" ( "gid" SERIAL, PRIMARY KEY 
> ("gid") )' statement, it makes me wonder if you are not using an older 
> GDAL version (Newer versions will issue a CREATE TABLE with all columns) 
> that might have trouble with overwriting existing tables and schemas.
> 
> Note for everyone: please mention the version you are using.

Sorry, I know that:

$ ogrinfo --version
GDAL 1.10.1, released 2013/08/26

on Ubuntu 14.04.5 LTS

ok, it is not as convenient but I can drop the table rather than rely on 
-overwrite.

Thanks,
   -Steve

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus