Feature request #11792

import - primary key option as combobox

Added by Luca Lanteri over 9 years ago. Updated about 7 years ago.

Category:DB Manager
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:20018


when import change the primary key option from text to combobox and allow to choose only from existing field.


#1 Updated by Giuseppe Sucameli over 8 years ago

  • Status changed from Open to Feedback

Maybe we could change it to an editable combobox, populating it with the source table columns.

This way:
1. user is allowed to either choose an existent field or choose a different name for pk,
2. user can create a new table with a primary key even if the original table has no one,
3. user can import data without the need to click on "Update options" button (that button loads the layer to gather the required info but it may require some time depending on the datasource).

ogr2ogr allows to choose the pk field name (see http://www.gdal.org/drv_pg.html), I guess we should keep this option available.

Suggestions are welcome.

#2 Updated by Giovanni Manghi about 7 years ago

  • Easy fix? set to No

Also available in: Atom PDF