Bug report #15768

DB Manager - Update SQL layer is not available when using column with unique values

Added by Jérôme Guélat almost 5 years ago. Updated over 3 years ago.

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


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


#1 Updated by Giovanni Manghi over 4 years ago

  • Easy fix? set to No
  • Regression? set to No

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

  • Category set to Unknown

#3 Updated by Jérôme Guélat over 3 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 over 3 years ago

  • Resolution set to fixed/implemented
  • Description updated (diff)

Also available in: Atom PDF