[Qgis-user] Editing a Postgis view

[Matthias Kuhn]

Hi Andrea,

It works here.
Do you have an instead of insert rule written on your view?
It works for me this way (but my views are too complicated for postgres
to create default insert rules by default anyway).
You can also try to alter your view with a default value for the column
in question.

Best regards
Matthias

On 11/16/2016 08:15 AM, Andrea Peri wrote:
> Hi,
> I'm having some trouble to edit a postgis view using qgis.
> 
> The view is a simple:
> select list-of-field from table1;
> 
> And the table1 is a table with a Primary key on a serial type field.
> 
> I add the first record and all was ok. The commit too.
> When go to add the second record.
> I start to have trouble.
> The qgis report my always a constraint violation of the pk.
> I try to leave the pk field empty, or try to fill it with a value.
> No solution work.
> 
> So my question is if is confirmed that qgis (I use the 2.18) version)
> is working in editing with a postgis view .
> 
> Thx.
> A.
> 
> 
>