Il 11/05/2017 17:09, Paolo Cavallini ha scritto:
> Hi all,
> with QGIS 2.18, when inserting records in a versioned view, created with
> DB Manager, I receive an error:
>
> ERROR: cannot perform
> INSERT RETURNING on relation "version_current"
>
> HINT: You need an unconditional ON INSERT DO INSTE
Hi Paolo,
QGIS 2.18 expects a view to return the newly created row including
values generated server side. This way the primary key of a newly
created feature can directly be used (e.g. to set the foreign key of
another feature).
So, this is definitely a feature and not a bug ;)
What you can do
Hi all,
with QGIS 2.18, when inserting records in a versioned view, created with
DB Manager, I receive an error:
ERROR: cannot perform
INSERT RETURNING on relation "version_current"
HINT: You need an unconditional ON INSERT DO INSTEAD rule with a
RETURNING clause.
The same operation on the same