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

[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 if I ask to ogr2ogr to export to 
shapefile a full schema.
Instead if I ask to ogr2ogr to export only one table using the -sql 
"select * from table_test" , the primary key integer is correctly exported.

Andrea.


Il 14/01/2012 11:59, Chaitanya kumar CH ha scritto:
> 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 <aperi2007 at gmail.com
> <mailto:aperi2007 at gmail.com>> 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 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 shapefile.
>     Both report the lost of the field PK.
>
>     The sintax I'm using is this:
>
>     ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES
>     -f "SQLite" prova.sqlite -progress PG:"dbname='test' active_schema=work
>     schemas=work host='local' port='5432' user='postgres'
>     password='postgres' " -overwrite -lco LAUNDER=yes -dsco SPATIALITE=yes
>     -lco SPATIAL_INDEX=yes -gt 65536
>
>     Thx,
>
>     Andrea.
>
>     _________________________________________________
>     gdal-dev mailing list
>     gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
>     http://lists.osgeo.org/__mailman/listinfo/gdal-dev
>     <http://lists.osgeo.org/mailman/listinfo/gdal-dev>
>
>
>
>
> --
> Best regards,
> Chaitanya kumar CH.
>
> +91-9494447584
> 17.2416N 80.1426E