<html><head></head><body>I'm not saying the old behaviour is correct.<br>
<br>
I'm saying the new behavior isn't friendly to non expert users. Loading from a database is no more difficult than loading a shapefile in most cases. I have clients and students do it quite often and "windowing function" means nothing and "primary key" is only a vague notion.<br>
<br>
Please don't just accept a broken ui because its something _you think_ only "relatively advanced" users will use.<br>
<br>
Moving towards a solution: how would people feel about a window appearing after selecting a view specifically asking which field to use (if one wasn't selected in the initial drop down). Alternatively, moving the in-row drop down to the beginning of the row so that small window sizes don't cut it off, and putting a yellow warning on it to draw attention. <br>
<br>
Jim<br><br><div class="gmail_quote">On September 1, 2015 11:36:09 AM EDT, Andreas Neumann <a.neumann@carto.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">Hi,<br /><br />I would regard the loading of layers from a database something <br />"relatively advanced". Normally I prepare ready to use QGIS project to <br />my users who edit and query our GIS data where they don't have to bother <br />with loading layers.<br /><br />But you are correct that it can be different persons - the one who <br />creates the view and the ones who are loading them.<br /><br />You are welcome to improve the situation/GUI, but please don't go back <br />to the old behavior where it is an assumption that the first column in <br />the list is always the primary key.<br /><br />Andreas<br /><br />On 01.09.2015 14:51, James Keener wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> Why are you assuming the user who created the view is the one using QGIS?<br /><br /> Jim<br /><br /> On 09/01/2015 08:50 AM, Andreas Neumann wrote:<br /><blockquote
class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> Hi,<br /><br /> I agree with Jürgen - better let the user choose the pkey column. If the<br /> user knows how to create a Postgis View he also knows how to select a<br /> primary key column.<br /><br /> Andreas<br /><br /> On 01.09.2015 14:37, Jürgen E. Fischer wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;"> Hi Sandro,<br /><br /> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"> I agree with Luca this should have been better not backported to 2.8.3.<br /> Only proper bugs should be backported, and this was a (debatable)<br /> GUI enhancement, as far as I can tell.<br /></blockquote> We intend to only backport fixes and not bugs. ;)<br /><br /> You were always
supposed to select the key column - preselecting the first<br /> column was the bug (also debatable). And #11317 is a ticket that demonstrates<br /> there were unaware users.<br /><br /> That the first column often happens to be the primary key and and the combobox<br /> is not lexically sorted is somewhat pure luck - and unless you avoid having the<br /> key verified (using "use estimated metadata"), keeping a wrongly select<br /> column will make the layer to insert invalid.<br /><br /> But I agree that the tooltip that you get on disabled lines (not only for the<br /> key selection, but also geometry type and srid) might not be visible enough<br /> (but that IMHO would be just a GUI enhancement).<br /><br /><br /> Jürgen<br /><br /><br /><br /><hr /><br /> Qgis-user mailing list<br /> Qgis-user@lists.osgeo.org<br /> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /></blockquote><br /><br /><hr /><br />
Qgis-user mailing list<br /> Qgis-user@lists.osgeo.org<br /> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote><br /></blockquote><br /></pre></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>