I have a PostgreSQL database which is accessed by multiple users and each user have different levels of privileges on tables and views. To insert/update/delete features, the users have to work on QGIS.
Let's get to the problem.
I have created a view on MultiLineString data. When i use basic editing tools like add feature, node tool, delete tool and move feature, everything works fine and the edits save successfully. But when i use advance editing tools like split feature, merge features it gives me strange behavior. When i split a linestring and save the edits, one of the splitted segments disappear. when i merge two segments and save edits, the merged segment disappears.
I tested the advance editing tools i.e. split and merge, on the table from which the above view is created and everything works fine, i am able to save merged and splitted features.
Version: PostgreSQL 9.5 and QGIS 2.18.2