[QGIS-trac] Re: [Quantum GIS] #1535: qgspostgresprovider choosing non-unique column as primary key

Quantum GIS qgis at qgis.org
Fri Feb 20 01:50:08 EST 2009


#1535: qgspostgresprovider choosing non-unique column as primary key
-----------------------------------------------------+----------------------
        Reporter:  jcs                               |         Owner:  nobody       
            Type:  bug                               |        Status:  new          
        Priority:  major: does not work as expected  |     Milestone:  Version 1.0.2
       Component:  Data Provider                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:  postgres     
Platform_version:                                    |      Platform:  All          
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by gjm):

 I think that we also need to provide this sort of UI functionality:

 - when selecting tables to load, allow the user to indicate that he/she
 wants to select the id column manually (and be prompted for it)
 - when no suitable columns are found automatically, prompt the user to
 choose a suitable column

 In both cases, qgis should continue to check that the column contains
 unique data.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1535#comment:4>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list