[QGIS-trac] Re: [Quantum GIS] #952: Support PostgreSQL uuid type

[Quantum GIS]

#952: Support PostgreSQL uuid type
----------------------------------------------------+-----------------------
        Reporter:  christiangda                     |         Owner:  jef          
            Type:  enhancement                      |        Status:  new          
        Priority:  minor: annoyance or enhancement  |     Milestone:  Version 2.0.0
       Component:  Data Provider                    |       Version:  HEAD         
      Resolution:                                   |      Keywords:  uuid         
Platform_version:                                   |      Platform:  All          
        Must_fix:  No                               |   Status_info:  0            
----------------------------------------------------+-----------------------
Comment (by mwtoews):

 A suggested workaround for this is to:
  1. drop the primary key constraint
  1. add a unique key constraint on the uuid column (former pkey)
  1. add a serial column (this could be on the far right-side .. doesn't
 matter)
  1. create a primary key on the newly created serial column

 FYI, very few GIS programs allow a non-integer primary key.

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