Opened 17 years ago

Closed 4 years ago

#1006 closed defect (wontfix)

GDAL ODBC driver should provide the possibility to specify FID field

Reported by: szekerest@… Owned by: warmerdam
Priority: normal Milestone: closed_because_of_github_migration
Component: OGR_SF Version: unspecified
Severity: normal Keywords:


GDAL ODBC driver should provide the possibility to specify FID field, so as to 
bring GetFeature into effect. Otherwise the whole result set of a layer will 
be tranferred to the client side.

It would be convenient to consider at least the field named "ogc_fid" as FID 

In the current implementation primary key detection does not seem to work. And 
for SQL views cannot be used at all.


Change History (3)

comment:1 by warmerdam, 17 years ago


In the current CVS version of GDAL/OGR you can set the 
ODBC_OGR_FID configuration variable to force selection
of a particular field as the FID.  However, this configuration
variable is global, not per layer, so it isn't really ideal. 

I am going to leave this bug report open as a request to 
be able to specify the FID field in the connection string
when listing table(s) explicitly. 

BTW, configuration variables can be set as environment

comment:2 by Even Rouault, 7 years ago

Priority: highnormal

All those tickets have more than one year and nobody has acted on it, so the priority is not so high

comment:3 by Even Rouault, 4 years ago

Milestone: closed_because_of_github_migration
Resolution: wontfix
Status: assignedclosed

This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to if it is not already reported there.

Note: See TracTickets for help on using tickets.