Bug report #6226

Primary key field hidden on attributes tables addes to qgis

Added by bradypus - almost 12 years ago. Updated over 8 years ago.

Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:duplicate
Crashes QGIS or corrupts data:No Copied to github as #:15537


Adding a sqlite text table (Layer > Add Vector Table) QGIS hides the primary key field (named `id`). The `id` field can not be used for references, queries or joins.
The ID field should be displayed and usable at least in read-only actions, such as queries, joins etc.

More information can be found here: http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis and here http://comments.gmane.org/gmane.comp.gis.qgis.user/18353

Related issues

Related to QGIS Application - Bug report #11498: spatialite layer added via browser lose first field Closed 2014-10-25


#1 Updated by Giovanni Manghi almost 12 years ago

  • Category set to Vectors
  • Target version set to Version 2.0.0

#2 Updated by Jürgen Fischer almost 10 years ago

  • Target version changed from Version 2.0.0 to Future Release - Lower Priority

#3 Updated by Médéric RIBREUX over 8 years ago

  • Status changed from Open to Feedback

Hello, bug triage...

I can't reproduce it on QGIS 2.13 master (and it should also be the case in QGIS 2.12.1).
When I am loading a SQLite non geographic table (and it is also true for geographic ones), the ID primary key is always displayed and editable. I can make joins on it.

Can you confirm that this bug is fixed ?

#4 Updated by Giovanni Manghi over 8 years ago

  • Status changed from Feedback to Closed
  • Resolution set to duplicate

duplicate of #11498

#5 Updated by Jürgen Fischer over 8 years ago

  • Subject changed from Primary key field hidden on atributes tables addes to qgis to Primary key field hidden on attributes tables addes to qgis

Also available in: Atom PDF