3

This is a follow-up question on how to Delete multiple features easily in QGIS?.

When hitting the delete button after selecting a set of features from a PostGIS table, QGIS reports an error:

Provider does not support deletion: Data provider does not support deleting features.

This is with QGIS 3.0 and after enabling edit mode using the edit toolbar. Apparently, I can add a new feature but not allowed to delete it.

Is there a workaround on this to allow deleting PostGIS features interactively?

  • hm I can´t seem reproduce that error on DB role management level...double checked all privileges and roles involved? a rather brutish workaround would be to create a temp layer from the selection and replace the DB table via upload (check replace destination table)... – ThingumaBob Jun 13 '18 at 12:21
5

Had same problem with a PG table. The problem was that the table had no primary key.

Added a serial column as PK, removed and re-added the table in QGIS. Problem solved.

Maybe the error msg should be more specific.

0

Is it possible the underlying PostgreSQL user does not have delete permissions? If so you will not be able to delete features in QGIS.

  • Thanks for the input. The postgresql account I use in QGIS is the database owner. I just tested DELETE FROM that table, and was able to delete all the features via SQL. – tinlyx Jun 12 '18 at 22:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.