https://issues.qgis.org/https://issues.qgis.org/favicon.ico2016-05-13T04:11:23ZQGIS Issue TrackingQGIS Application - Bug report #14813: Add PostGIS view -- primary key is ignoredhttps://issues.qgis.org/issues/14813?journal_id=699792016-05-13T04:11:23ZJürgen Fischerjef@norbit.de
<ul></ul><p>The arbitray pre-selection of the first column is gone. You are now required to select the primary keys (one or more columns).</p> QGIS Application - Bug report #14813: Add PostGIS view -- primary key is ignoredhttps://issues.qgis.org/issues/14813?journal_id=699802016-05-13T04:27:03ZThomas Kandlerhallo@thomaskandler.net
<ul></ul><p>Jürgen Fischer wrote:</p>
<blockquote>
<p>The arbitray pre-selection of the first column is gone. You are now required to select the primary keys (one or more columns).</p>
</blockquote>
<p>Any rationale for this? I am just wondering since even a arbitrary selection would be as efficient as the mandatory selection at worst; and in many cases more efficient since I save 2 clicks per layer/view.</p>
<p>P.S. Issue can be closed; I will do asap.</p> QGIS Application - Bug report #14813: Add PostGIS view -- primary key is ignoredhttps://issues.qgis.org/issues/14813?journal_id=699812016-05-13T04:52:39ZThomas Kandlerhallo@thomaskandler.net
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul> QGIS Application - Bug report #14813: Add PostGIS view -- primary key is ignoredhttps://issues.qgis.org/issues/14813?journal_id=699882016-05-15T21:35:06ZJürgen Fischerjef@norbit.de
<ul></ul><p>Thomas Kandler wrote:</p>
<blockquote>
<p>Jürgen Fischer wrote:</p>
<blockquote>
<p>The arbitray pre-selection of the first column is gone. You are now required to select the primary keys (one or more columns).</p>
</blockquote>
<p>Any rationale for this? I am just wondering since even a arbitrary selection would be as efficient as the mandatory selection at worst; and in many cases more efficient since I save 2 clicks per layer/view.</p>
</blockquote>
<p>QGIS doesn't know what the unique column is and was always supposed to be selected. The preselection was hiding this and led to reports of strange effects when it wasn't unique.</p> QGIS Application - Bug report #14813: Add PostGIS view -- primary key is ignoredhttps://issues.qgis.org/issues/14813?journal_id=699892016-05-15T22:11:13ZThomas Kandlerhallo@thomaskandler.net
<ul></ul><p>Jürgen Fischer wrote:</p>
<blockquote>
<p>QGIS doesn't know what the unique column is and was always supposed to be selected. The preselection was hiding this and led to reports of strange effects when it wasn't unique.</p>
</blockquote>
<p>Thank you very much for the clarification. I'd taken another approach but I am also not a contributing dev. Anyhow, I guess <a class="issue tracker-2 status-1 priority-4 priority-" href="https://issues.qgis.org/issues/14367" title="Define a default name of the unique integer column for PostGIS layer (Open)">#14367</a> could be a well worth investment for folks who have a lot of PostGIS views (spanning multiple DBs) in their everyday work.</p>