Bug report #15768
DB Manager - Update SQL layer is not available when using column with unique values
Status: | Closed | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | Unknown | ||
Affected QGIS version: | 2.18.0 | Regression?: | No |
Operating System: | Windows | Easy fix?: | No |
Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 23690 |
Description
It is impossible to update SQL layers (item doesn't appear in the context menu) when you select an available column with unique values. Here are the steps to reproduce:
1. Make a SQL query in DB Manager
2. Activate the "Load as new layer checkbox"
3. Choose an available column with unique values (instead of letting QGIS generate it for you)
4. Load the layer: you can't update it when you right-click on the layer name
History
#1 Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
- Regression? set to No
#2 Updated by Jürgen Fischer about 7 years ago
- Category set to Unknown
#3 Updated by Jérôme Guélat almost 7 years ago
- Status changed from Open to Closed
This is now working in QGIS 3.0. However it doesn't work if you let QGIS generates the ID for you.
#4 Updated by Giovanni Manghi almost 7 years ago
- Resolution set to fixed/implemented
- Description updated (diff)