Data provider does not support deleting features for PostGIS tables?

Question

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)... — geozelot, Jun 13 '18 at 12:21

rov66 · Accepted Answer · 2018-08-27 20:08:10Z

7

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.

answered Aug 27 '18 at 20:08

rov66

711 silver badge2 bronze badges

add a comment |

Geo Spatial · Accepted Answer · 2018-06-12 22:02:26Z

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.

answered Jun 12 '18 at 22:02

Geo Spatial

11 bronze badge

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

add a comment |

2 Answers 2