Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am able to successfully run ogr2ogr to add S57 data to PostgresDB. The version I use is GDAL 1.7.0b2, FWTools 2.4.7 and release date 2010/01/19

I upgraded my version to GDAL 1.9.1 and release date 2012/05/16. When I run ogr2ogr on the same files, I get an error as follows

ERROR 1: Layer dsid already exists, CreateLayer failed.
Use the layer creation option OVERWRITE=YES to replace it.
ERROR 1: Terminating translation prematurely after failed
translation of layer DSID (use -skipfailures to skip errors)

Why would this happen when all things being equal? Is the latest version buggy?

share|improve this question
Neither -overwrite not -lco OVERWRITE=YES nor --config OVERWRITE yes works! Sigh! – user57024 Aug 20 '15 at 17:21
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. – Evil Genius Aug 20 '15 at 18:35
up vote 6 down vote accepted

It would appear that GDAL 1.9.1 (note that 1.9.2 is out now) does not allow creating on top of an existing layer. Perhaps the older version was more permissive.

Why not just try adding -lco OVERWRITE=YES to your ogr2ogr command if you don't mind replacing your existing tables in Postgres?

share|improve this answer
Thanks Frank. That seem to work without errors (but lots of warnings though). My database needs to get refreshed periodically based on S57 updates, so a complete overwrite is not a concern. – Ramesh Elaiyavalli Oct 29 '12 at 15:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.