[QGIS-trac] Re: [Quantum GIS] #62: Qgis only supports postgres keys of type int

[Quantum GIS]

#62: Qgis only supports postgres keys of type int
-----------------------------------------------------+----------------------
        Reporter:  g_j_m                             |         Owner:  jef          
            Type:  enhancement                       |        Status:  new          
        Priority:  major: does not work as expected  |     Milestone:  Version 2.0.0
       Component:  Data Provider                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  All          
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by gjm):

 An email from the developers mailing list (Sun, 31 Aug 2008 02:42:42
 +1200):


   Currently QGIS requires a int4 column with unique IDs for accessing data
   in a PostGIS database. I routinely work with OpenStreetMap data which
   uses int8 for its IDs. Currently the OSM IDs still fit into an int4, but
   this will not work forever. At the moment its a bit of a hassle that I
   always have to keep this limitation in mind.

   Is the limitation on int4 columns something hardcoded deep in the code
   or is it something that could be changed reasonably easy? I understand
   the need for a unique ID column, but it would be nice if the data type
   was more flexible. I think at least int2, int4, and int8 should be
   supported.

   Jochen Topf

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