Hi, Sorry to revive this post but I'm a non GIS type and have a similar issue.
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 OVERWRITE=YES -T_SRS EPSG:27700 *The Error we get* failed with return code 1 and error message ERROR 1: CREATE TABLE "public"."windturbines" ( OGC_FID SERIAL, CONSTRAINT "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! Pete -- 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. _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
