Thx for response.
I 'm testing better.
But the strange is that the first write was regulrly executed.
If the view was really read-only it should refuse also the first write.
Instead only from the second write I have the error.
And the qgis don't report me a "readonly view.
But instead a "id primary key cannot be nul" constraint violation.
I try to understand better all of this.
2016-11-16 15:54 GMT+01:00 Carlo A. Bertelli (Charta s.r.l.)
> Ciao Andrea,
> by default Postgresql views are read only. Even the simplest view made in
> Postgresql needs a rule to be updated. After writing a statement for a view,
> just take the habit of writing the rules for insert, update, delete.
> Please read the chapter on the Rule System in the Postgresql Reference
> Manual for the instructions.
> Message: 6
> Date: Wed, 16 Nov 2016 09:39:23 +0100
> From: Andrea Peri <aperi2...@gmail.com>
> To: Matthias Kuhn <matth...@opengis.ch>
> Cc: qgis-user <email@example.com>
> Subject: Re: [Qgis-user] Editing a Postgis view
> Content-Type: text/plain; charset=UTF-8
> Hi Matthias,
> thx for response.
> So the trouble is in my db.
> Now I try to understand better why it is not working.
> This is my actual try test:
> create table schemaapp.repository(
> ID serial primary key NOT NULL,
> UUID varchar(50) NOT NULL,
> PROGETTO varchar(9) NOT NULL,
> PROCEDIMENTO text NOT NULL,
> GEOMETRIA1 geometry(MULTIPOINT, 3003)
> create view schemaapp.v_repository_point as
> a.id as id,
> a.uuid as uuid,
> a.progetto as progetto,
> a.procedimento as procedimento,
> a.geometria1 as geometria
> schemappa.repository_wfs as a
> a.geometria1 is not null;
> I will know if discover something.
> thx again.
> 2016-11-16 8:54 GMT+01:00 Matthias Kuhn <matth...@opengis.ch>:
>> 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
>> On 11/16/2016 08:15 AM, Andrea Peri wrote:
>>> 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 .
>> Qgis-user mailing list
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Qgis-user mailing list
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
. . . . . . . . .
Qgis-user mailing list
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user