On 17 Nov 2016 4:45 AM, "Carlo A. Bertelli (Charta s.r.l.)" < carlo.berte...@gmail.com> wrote: > > 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...
Yes, it's a nice feature, but the very limited requirements when this kicks in generally prevent it from being usable with real views. Nyall > c > > On Wed, Nov 16, 2016 at 7:22 PM, Nyall Dawson <nyall.daw...@gmail.com> wrote: >> >> On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" < carlo.berte...@gmail.com> 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 <aperi2...@gmail.com> >> > To: Matthias Kuhn <matth...@opengis.ch> >> > Cc: qgis-user <qgis-user@lists.osgeo.org> >> > Subject: Re: [Qgis-user] Editing a Postgis view >> > Message-ID: >> > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik= tugwwckd...@mail.gmail.com> >> > 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 <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 >> > > 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 >> > > Qgis-user@lists.osgeo.org >> > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >> > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
