<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 12, 2020 at 9:05 AM Paolo Cavallini <<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">HHhi all,<br>
thanks Alessandro for fixing it. Any hope to backport it to 3.4? This<br></blockquote><div><br></div><div><br></div><div>Nope, 3.4 is EOL</div><div><br></div><div>there is a bp here for 3.10 though:</div><div><br></div><div> <a href="https://github.com/qgis/QGIS/pull/34291">https://github.com/qgis/QGIS/pull/34291</a></div><div><br></div><div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
raises again the issue of long term releases, and their interaction with<br>
upgrades of related sw.<br>
Cheers.<br>
<br>
Il 11/02/20 17:15, Régis Haubourg ha scritto:<br>
> Oh, I see my master is old. I thought I recompiled it last week. I'll<br>
> check again. Let's compile.<br>
> Regards<br>
> Régis<br>
> <br>
> Le mar. 11 févr. 2020 à 15:12, Alessandro Pasotti <<a href="mailto:apasotti@gmail.com" target="_blank">apasotti@gmail.com</a><br>
> <mailto:<a href="mailto:apasotti@gmail.com" target="_blank">apasotti@gmail.com</a>>> a écrit :<br>
> <br>
> <br>
> Wierd, I thought I fixed that: there is a test too,<br>
> <a href="https://github.com/qgis/QGIS/pull/34017/files#diff-99b101819133a316786604243f3abf6eR1432" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/pull/34017/files#diff-99b101819133a316786604243f3abf6eR1432</a><br>
> <br>
> feel free to reopen and provide additional test details or test cases.<br>
> <br>
> <a href="https://github.com/qgis/QGIS/pull/34017" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/pull/34017</a><br>
> <br>
> <br>
> On Tue, Feb 11, 2020 at 3:05 PM Régis Haubourg<br>
> <<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a> <mailto:<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a>>> wrote:<br>
> <br>
> For the record here are my SQL commands:<br>
> drop table if exists data.pipe;<br>
> <br>
> CREATE TABLE data.pipe<br>
> (<br>
> id integer NOT NULL ,<br>
> label_1_text character varying(120) COLLATE<br>
> pg_catalog."default",<br>
> _length2d numeric(8,2) GENERATED ALWAYS AS<br>
> (st_length2D(geometry)) STORED,<br>
> _length3d numeric(8,2) GENERATED ALWAYS AS<br>
> (ST_3DLength(geometry)) STORED,<br>
> geometry geometry(LineStringZ,3946) NOT NULL,<br>
> CONSTRAINT pipe_pkey PRIMARY KEY (id)<br>
> );<br>
> <br>
> INSERT INTO<br>
> "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d")<br>
> VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),2<br>
> ,'test',DEFAULT, DEFAULT);<br>
> <br>
> Le mar. 11 févr. 2020 à 15:03, Régis Haubourg<br>
> <<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a> <mailto:<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a>>> a<br>
> écrit :<br>
> <br>
> Hi Paolo,<br>
> nice feature, thanks for the heads up !<br>
> <br>
> I confirm the behavior here.<br>
> <br>
> The documentation advises to use the `DEFAULT` keyword into<br>
> the INSERT command.<br>
> Here is what I get with a QGIS-like insert :<br>
> <br>
> INSERT INTO<br>
> "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d")<br>
> VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),1<br>
> ,'test',0, 0);<br>
> ERREUR: 42601: ne peut pas insérer dans la colonne «<br>
> _length2d »<br>
> DÉTAIL : Column "_length2d" is a generated column.<br>
> EMPLACEMENT : rewriteTargetListIU, rewriteHandler.c : 827<br>
> <br>
> With the keyword 'DEFAULT', it works<br>
> <br>
> INSERT INTO<br>
> "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d")<br>
> VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),2<br>
> ,'test',DEFAULT, DEFAULT);<br>
> <br>
> And with no data supplied for the generated columns, it also<br>
> works<br>
> <br>
> We indeed have to upgrade the postgresql provider to check<br>
> this particular column type to handle INSERT and UPDATE<br>
> accordingly.<br>
> <br>
> Regards<br>
> <br>
> Régis<br>
> <br>
> <br>
> Le mar. 11 févr. 2020 à 13:59, Paolo Cavallini<br>
> <<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a> <mailto:<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>>> a écrit :<br>
> <br>
> Hi all,<br>
> PostgreSQL 12 has the option of a GENERATED ALWAYS AS<br>
> ... STORED column.<br>
> QGIS is able to load the table, but apparently it is not<br>
> possible to<br>
> insert new records. Does anyone confirm that this is not<br>
> a local problem?<br>
> All the best.<br>
> -- <br>
> Paolo Cavallini - <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a> <<a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">http://www.faunalia.eu</a>><br>
> <a href="http://QGIS.ORG" rel="noreferrer" target="_blank">QGIS.ORG</a> <<a href="http://QGIS.ORG" rel="noreferrer" target="_blank">http://QGIS.ORG</a>> Chair:<br>
> <a href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" rel="noreferrer" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a><br>
> _______________________________________________<br>
> QGIS-Developer mailing list<br>
> <a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a>><br>
> List info:<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> Unsubscribe:<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> <br>
> _______________________________________________<br>
> QGIS-Developer mailing list<br>
> <a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
> <mailto:<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a>><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> <br>
> <br>
> <br>
> -- <br>
> Alessandro Pasotti<br>
> w3: <a href="http://www.itopen.it" rel="noreferrer" target="_blank">www.itopen.it</a> <<a href="http://www.itopen.it" rel="noreferrer" target="_blank">http://www.itopen.it</a>><br>
> <br>
<br>
-- <br>
Paolo Cavallini - <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a><br>
<a href="http://QGIS.ORG" rel="noreferrer" target="_blank">QGIS.ORG</a> Chair:<br>
<a href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" rel="noreferrer" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature">Alessandro Pasotti<br>w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a></div></div>