Bug report #14058

editing layers created with DB Manager

Added by Mart Reinola about 7 years ago. Updated about 7 years ago.

Category:DB Manager
Affected QGIS version:2.6.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:22068


I noticed a strange behavior in layers created with DB manager. Tested it in QGIS 2.6.1 and QGIS 2.12.0

In QGIS 2.6.1. When i create a layer based on a sql query with the setting "Avoid selecting by feature id" turned off, i cannot start editing session on this new layer. The "start editing" button is inactive. When i create a layer based on the same sql query with "Avoid selecting by feature id" turned on, the editing button in QGIS gets activated, i can start editing session but "Add feature" and "Save layer edits" buttons stay inactive. I can move any features or nodes on a feature, but still i cannot save the edits.

In QGIS 2.12.0 there is no difference, whether i set "Avoid selecting by feature id" on or off, editing button is inactive and i cannot start editing session.

Is it a bug, am i doing something wrong or is QGIS ment to behave like this? And what is this "Avoid selecting by feature id" option for?

O, and the data i want to edit comes from a PostGis database.


#1 Updated by Giovanni Manghi about 7 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

I don't think that this option is related to editing capabilities of the loaded layer from query


it seems to me that it was a bug in qgis 2.6, that was fixed since 2.8 (it seems). The loaded layers from queries in db manager as views, so it seems right are not editable.

Please reopen if necessary.

Also available in: Atom PDF