Bug report #5402

MS SQL Server native driver not detecting primary key of tables

Added by Carlos da Ponte over 7 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Tamas Szekeres
Category:Data Provider/MSSQL
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:15070

Description

Tables are all listed and all other attributes of the tables are detected by the driver with the exception of the Primary Key. A GID auto-incremented field is present on all tables to act as a primary key for QGIS. Please provide details on proper table structure and I will verify everything is correct on our end.

thanks!

History

#1 Updated by Tamas Szekeres over 7 years ago

  • Assignee set to Tamas Szekeres

#2 Updated by Tamas Szekeres about 7 years ago

  • Status changed from Open to Feedback

There have been some changes related to the pk detection in the mssql driver. Would you check whether it fixes this problem or not?

#3 Updated by Paolo Cavallini about 7 years ago

  • Target version set to Version 2.0.0

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

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

closing for the lack of feedback

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

  • Category set to Data Provider/MSSQL

Also available in: Atom PDF