Bug report #9590
postgis table primary key choice list mixes fields from different tables or view
|Affected QGIS version:||2.0.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||18170|
Primary key choice list in postgis connection dialog does show much more field than real table or view has.
Good table fields appears in the lower end of the dropdown list. I can even see technical fields or postgres system table.
This might be related to slow scanning of fields, because too much fields are scanned.
see image here, the field insee_commune is almost always proposed by default when it exists really on a few tables.