Thank you Nyall for fixing my "conservative" and unduly generalised assumption. A thought it was an older version, as updatable views handle rules/sequences with some careful nonchalance, especially for views on a table only. Unfortunately no database can handle logic problems at the conceptual level. I don't know if a future version of any RDBMS wil... c
On Wed, Nov 16, 2016 at 7:22 PM, Nyall Dawson <[email protected]> wrote: > On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" < > [email protected]> wrote: > > > > Ciao Andrea, > > by default Postgresql views are read only. Even the simplest view made > in Postgresql needs a rule to be updated. > > That's not quite correct. Recent versions of postgres make simple views > editable. > See > > https://www.depesz.com/2012/12/11/waiting-for-9-3-support- > automatically-updatable-views/ > > Nyall > > 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. > > c > > > > Message: 6 > > Date: Wed, 16 Nov 2016 09:39:23 +0100 > > From: Andrea Peri <[email protected]> > > To: Matthias Kuhn <[email protected]> > > Cc: qgis-user <[email protected]> > > Subject: Re: [Qgis-user] Editing a Postgis view > > Message-ID: > > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=tUGWwcKd > [email protected]> > > 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 > > select > > a.id as id, > > a.uuid as uuid, > > a.progetto as progetto, > > a.procedimento as procedimento, > > a.geometria1 as geometria > > from > > schemappa.repository_wfs as a > > where > > a.geometria1 is not null; > > > > I will know if discover something. > > thx again. > > > > 2016-11-16 8:54 GMT+01:00 Matthias Kuhn <[email protected]>: > > > 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. > > >> > > >> > > >> > > > _______________________________________________ > > > Qgis-user mailing list > > > [email protected] > > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
