[Qgis-developer] Postgis Spatial Views - problems with primary keys
senhor.neto at gmail.com
Tue Mar 18 02:59:32 PDT 2014
I have opened a ticket:
On Tue, Mar 11, 2014 at 12:08 PM, Alexandre Neto <senhor.neto at gmail.com>wrote:
> Hello all,
> Regarding this matter, should I make a ticket? Or is the general
> understanding that the described behavior is ok as it is?
> Alexandre Neto
> On Mon, Mar 10, 2014 at 2:39 PM, Alexandre Neto <senhor.neto at gmail.com>wrote:
>> Hi Jürgen,
>> On Mon, Mar 10, 2014 at 12:30 PM, Jürgen E. <jef at norbit.de> wrote:
>>> QGIS just offers all integer fields as candidate. It doesn't select any.
>> If you use add Postgis layer dialog, it uses one of integer fields by
>> default in the primary key column (not always the same).
>>> I think that changed before 2.0.1. QGIS used to identify which view
>>> field are
>>> primary keys in the underlying tables, but that makes sense if the view
>>> is a
>>> selection of that table, which is just a very small subset of possible
>>> E.g. for joins between two tables being a primary key in one of the
>>> doesn't mean that the attribute is also unique in the view.
>> I have a Portuguese user that says that this 2.0.1 is working as before
>> (and that he won't change to 2.2 until it gets "fixed"), but personally I
>> can't confirm this.
>> What was the downside of the later behavior? I.e. qgis identifying
>> several primary keys and try to guess what to use? Even if it is a small
>> subset of possible views, I think it would make user's life easier in some
>> Also, as it is now, unless the view only have one integer field, the
>> browser became useless for adding views. We should, at least, change the
>> error message, informing the user that he must select a primary key
>> manually (only possible in the add postgis layer dialog).
>> Thanks for your answer.
>>> Jürgen E. Fischer norBIT GmbH Tel.
>>> Dipl.-Inf. (FH) Rheinstraße 13 Fax.
>>> Software Engineer D-26506 Norden
>>> QGIS PSC member (RM) Germany IRC: jef on
>>> norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
>>> Rheinstrasse 13, 26506 Norden
>>> GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Qgis-developer