[gdal-dev] Mapinfo --> postgis db using ogr2ogr, failing to overwrite

Pete petern at pembrokeshirecoast.org.uk
Thu Mar 14 05:22:10 PDT 2013

Hi, Sorry to revive this post but I'm a non GIS type and have a similar

I'm trying to upload a mapinfo layer using WinSCP and Ogr2Ogr to work it's
magic to put it into the GeoStore, this via GeoServer ensures our Openlayers
map is up-to-date.

The trouble is that I get the exact same error IF the existing table being
overwritten has views based on it, otherwise the overwrite works fine.

The views go to make up the layers on the map that can be turned on/off.  I
really don't want to end up with a table for each of these !

Is this possible ?   is there a better way of doing it ?  

*The command we’re using *
call ogr2ogr -f "PostgreSQL" PG:"host=localhost user=pembs dbname=pembs
password=12345" ./WindTurbines.TAB  -nln public.windturbines -lco

*The Error we get*
failed with return code 1 and error message
"windturbines_pk" PRIMARY KEY (OGC_FID) )
ERROR:  relation "windturbines" already exists
ERROR 1: Terminating translation prematurely after failed
translation of layer WindTurbines (use -skipfailures to skip errors).

Appologies again that i'm not a GIS bod so hope my lack of understanding
doesn't confuse you!


View this message in context: http://osgeo-org.1560.n6.nabble.com/Mapinfo-postgis-db-using-ogr2ogr-failing-to-overwrite-tp3743940p5040341.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.

More information about the gdal-dev mailing list