[QGIS-trac] Re: [Quantum GIS] #1718: Incorrect unique key interpretation on PostGIS view - view doesn't load as expected

[Quantum GIS]

#1718: Incorrect unique key interpretation on PostGIS view - view doesn't load as
expected
-----------------------------------------------------+----------------------
        Reporter:  mwtoews                           |         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:               
Platform_version:                                    |      Platform:  Windows      
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Comment (by jef):

 Replying to [comment:1 mwtoews]:
 > I didn't catch this in the error message above until now (emphasis
 mine):
 >   'sid' derives from 'public.analysis.sid' '''and is suitable'''.
 >
 > This is a correct interpretation, but somehow this logic is not put to
 use and the error message is shown and the GIS view is not.

 QGIS fails to interpret the alternative names {{{spt}}}, {{{smp}}} and
 {{{ana}}}.  If you use the original names in the view the view is addable.

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