Re: [gdal-dev] ogr2ogr, preserve_fid and Postgres sequences

2017-09-07 Thread César Martínez
Done, thanks for the support: https://trac.osgeo.org/gdal/ticket/7032 César 2017-09-07 17:41 GMT+02:00 Even Rouault : > On jeudi 7 septembre 2017 17:05:36 CEST César Martínez wrote: > > > Hi Jukka, see answer inline: > > > > > > 2017-09-07 16:48 GMT+02:00 jratike80 maanmittauslaitos.fi>: > > >

Re: [gdal-dev] ogr2ogr, preserve_fid and Postgres sequences

2017-09-07 Thread Even Rouault
On jeudi 7 septembre 2017 17:05:36 CEST César Martínez wrote: > Hi Jukka, see answer inline: > > 2017-09-07 16:48 GMT+02:00 jratike80 : > > Hi César, > > > > What are the problems you face when editing such layer? > > If you later try to add a new record to the layer without providing an id, > i

Re: [gdal-dev] ogr2ogr, preserve_fid and Postgres sequences

2017-09-07 Thread César Martínez
Hi Jukka, see answer inline: 2017-09-07 16:48 GMT+02:00 jratike80 : > Hi César, > > What are the problems you face when editing such layer? If you later try to add a new record to the layer without providing an id, it will raise an error, defeating the purpose of having a serial PK. For instan

Re: [gdal-dev] ogr2ogr, preserve_fid and Postgres sequences

2017-09-07 Thread jratike80
Hi César, What are the problems you face when editing such layer? Do you have an alternative suggestion about what to do for the sequence? -Jukka Rahkonen- -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html ___ gdal-dev mailing

[gdal-dev] ogr2ogr, preserve_fid and Postgres sequences

2017-09-07 Thread César Martínez
Hi, When loading a layer on PostGIS using ogr2ogr, a sequence is created for the serial primary key. If -preserve_fid paramenter is provided, the sequence start is not properly initialized (i. e. sequence starts on 1). This leads to problems if the layer is later edited. Is this an intended behavi