Feature request #14344
Individual name for primary key in 'New SpatiaLite Layer' dialogue
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||22330|
Please allow users to set the name of the primary key individually in the 'New SpatiaLite Layer' dialogue (Crtl+Shift+A).
#2 Updated by Jukka Rahkonen over 4 years ago
The "Create autoincrementing primary key" exists there probably because of the word "autoincrementing". SQLite has always a primary key in the system "ROWID". Creating a synonym for ROWID as "COLUMN INTEGER PRIMARY KEY AUTOINCREMENT" makes fids stable so that that the rowids of deleted rows will not be reused.
Would you like to have two selections:
- prevent reuse of rowids of deleted features (autoincrement)
- select the name to be used as synonym for ROWID?