Hi,

I would regard the loading of layers from a database something "relatively advanced". Normally I prepare ready to use QGIS project to my users who edit and query our GIS data where they don't have to bother with loading layers.

But you are correct that it can be different persons - the one who creates the view and the ones who are loading them.

You are welcome to improve the situation/GUI, but please don't go back to the old behavior where it is an assumption that the first column in the list is always the primary key.

Andreas

On 01.09.2015 14:51, James Keener wrote:
Why are you assuming the user who created the view is the one using QGIS?

Jim

On 09/01/2015 08:50 AM, Andreas Neumann wrote:
Hi,

I agree with Jürgen - better let the user choose the pkey column. If the
user knows how to create a Postgis View he also knows how to select a
primary key column.

Andreas

On 01.09.2015 14:37, Jürgen E. Fischer wrote:
Hi Sandro,

On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
I agree with Luca this should have been better not backported to 2.8.3.
Only proper bugs should be backported, and this was a (debatable)
GUI enhancement, as far as I can tell.
We intend to only backport fixes and not bugs. ;)

You were always supposed to select the key column - preselecting the first
column was the bug (also debatable).  And #11317 is a ticket that demonstrates
there were unaware users.

That the first column often happens to be the primary key and and the combobox
is not lexically sorted is somewhat pure luck - and unless you avoid having the
key verified (using "use estimated metadata"), keeping a wrongly select
column will make the layer to insert invalid.

But I agree that the tooltip that you get on disabled lines (not only for the
key selection, but also geometry type and srid) might not be visible enough
(but that IMHO would be just a GUI enhancement).


Jürgen



_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to