[gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-13 Thread aperi2007
Hi, I notice that try-ing exporting from Postgres using ogr2ogr.exe It lost completely the primary key filed if that is a integer field. Instead it don't lost the same primary key field if it is a varchar type. Is a know bug this ? I'm use the gdal 1.9. I try exporting to a spatialite or to a

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-14 Thread Chaitanya kumar CH
Andrea, The integer primary column might be going into the sqlite datasource as the FID. On Sat, Jan 14, 2012 at 1:35 AM, aperi2007 wrote: > Hi, > > I notice that try-ing exporting from Postgres using ogr2ogr.exe > It lost completely the primary key filed if that is a integer field. > Instead i

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-15 Thread aperi2007
> The integer primary column might be going into the sqlite datasource >as > the FID. Hi Chaitanya, unfortunatelly seem no. To have a more test I try to export from PG to shapefile. I can confirm that the integer primary key field is lost in exportation. I notice also that this happened only i

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-21 Thread Even Rouault
Le dimanche 15 janvier 2012 15:20:32, aperi2007 a écrit : > > The integer primary column might be going into the sqlite datasource > > > >as > > > > the FID. > > Hi Chaitanya, > > unfortunatelly seem no. > > To have a more test I try to export from PG to shapefile. > I can confirm that the

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-21 Thread aperi2007
Hi Even, > I'm not sure why you see a difference of behaviour between the 2 >syntax. > Perhaps it is due to the way the primary key has been defined. It >might be that > when given by layer name, OGR detects the primary key column, whereas >it > doesn't when passed with -sql. Yes, but the issue

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-21 Thread Even Rouault
Andrea, Several points : 1) in the OGR data model, there is the concept of feature ID. According to http://gdal.org/ogr/ogr_arch.html : """The feature id (FID) of a feature is intended to be a unique identifier for the feature within the layer it is a member of. Freestanding features, or featur

Re: [gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

2012-01-22 Thread aperi2007
Hi, Even thx for you full explanation . :) It is really useful for me. Andrea. Il 21/01/2012 12:28, Even Rouault ha scritto: Andrea, Several points : 1) in the OGR data model, there is the concept of feature ID. According to http://gdal.org/ogr/ogr_arch.html : """The feature id (FID) of a f