[QGIS-trac] Re: [Quantum GIS] #1417: Unable to add a Postgis layer when the key attribut have an alias

[Quantum GIS]

#1417: Unable to add a Postgis layer when the key attribut have an alias
-----------------------------------------------------+----------------------
        Reporter:  mgrizonnet                        |         Owner:  nobody                         
            Type:  bug                               |        Status:  new                            
        Priority:  major: does not work as expected  |     Milestone:  Version 1.0.3                  
       Component:  Data Provider                     |       Version:  HEAD                           
      Resolution:                                    |      Keywords:  postgis layer/primary key/alias
Platform_version:                                    |      Platform:  Windows                        
        Must_fix:  No                                |   Status_info:  0                              
-----------------------------------------------------+----------------------
Comment (by pcav):

 Just tested with:

 mipi=> create view view1 as select cat, the_geom from fix where cat=2531;
 CREATE VIEW
 mipi=> create view view2 as select cat as id, the_geom from fix where
 cat=2531;
 CREATE VIEW

 and QGIS can load both layers without hassle: can you please check again
 and report back?

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