https://issues.qgis.org/https://issues.qgis.org/favicon.ico2019-04-09T15:35:17ZQGIS Issue TrackingQGIS Application - Bug report #21814: source fields list does not update when layer is overwrittenhttps://issues.qgis.org/issues/21814?journal_id=1038242019-04-09T15:35:17ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>This is not limited to GPKGs: for instance load a PostGIS table, then add a column from a different backend other than QGIS (or also in QGIS using db manager and a query), if you open the TA the new column will not show.</p>
<p>You may want to re-word this ticket subject and description then... but I'm almost sure that this is/was already filed.</p> QGIS Application - Bug report #21814: source fields list does not update when layer is overwrittenhttps://issues.qgis.org/issues/21814?journal_id=1038272019-04-09T15:42:32ZBrett CarlockSynper311@aol.com
<ul></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>This is not limited to GPKGs: for instance load a PostGIS table, then add a column from a different backend other than QGIS (or also in QGIS using db manager and a query), if you open the TA the new column will not show.</p>
<p>You may want to re-word this ticket subject and description then... but I'm almost sure that this is/was already filed.</p>
</blockquote>
<p>I can't speak to any other database engine than geopackage, as that is all I use at current.</p>
<p>However, it is interesting to note that you mention adding the column from another backend from QGIS.<br />In my above example, I'm only using QGIS from within the same session as where the data is loaded. I would think that in this manner these changes would be tracked/accounted for and the data would reflect this without having to Close/Re-Open the project.</p>
<p>Does your PostGIS behave as expected if you add a column via QGIS in the same session as I've outlined above?</p> QGIS Application - Bug report #21814: source fields list does not update when layer is overwrittenhttps://issues.qgis.org/issues/21814?journal_id=1038842019-04-10T16:10:35ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li><li><strong>Subject</strong> changed from <i>Source Fields list does not update when layer is overwritten in geopackage</i> to <i>source fields list does not update when layer is overwritten</i></li></ul><blockquote>
<p>I can't speak to any other database engine than geopackage, as that is all I use at current.</p>
<p>However, it is interesting to note that you mention adding the column from another backend from QGIS.<br />In my above example, I'm only using QGIS from within the same session as where the data is loaded. I would think that in this manner these changes would be tracked/accounted for and the data would reflect this without having to Close/Re-Open the project.</p>
<p>Does your PostGIS behave as expected if you add a column via QGIS in the same session as I've outlined above?</p>
</blockquote>
<p>Maybe mine was not the best example. Bottom line is that I see what you mean, but anyway as far as I can remember a full replacement of a a datasource (already loaded in a qgis project) from within qgis has never triggered a reload of the project (that is what you need if you want see the changes).</p>