[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 jef):

 since r10474 the postgres providers resorts to using
 [http://www.postgresql.org/docs/8.3/static/ddl-system-columns.html ctid]
 as feature id, if no other usable primary key is found.

 As a ctid currently consists of a 32bit block number and and 16bit offset,
 that option is limited to tables that have block numbers below 0x10000.

 That problem would also disappear by applying the patch above to implement
 64bit feature ids.

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