[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:  patch                             |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.6.0
  Component:  Data Provider                     |            Version:  Trunk        
   Keywords:                                    |   Platform_version:               
   Platform:  All                               |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------

Comment(by willfurnass):

 It would also be nice if PostGIS sequences could be used for layer keys.

 I frequently wish to view the result of applying PostGIS aggregate
 functions using QGIS but this can't be done using relational views as the
 results of such queries lack anything that could be used as a primary key;
 I therefore end up littering my db with temporary tables created using
 'SELECT...INTO...' so as to view the results of aggregate queries in QGIS.
 Allowing a self-incrementing sequence col within a view to be used as a
 layer key would be a (slightly ugly) way around this.

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