[QGIS-trac] Re: [Quantum GIS] #3820: Layer postgres dont recognize unique key index

[Quantum GIS]

#3820: Layer postgres dont recognize unique key index
------------------------------------------------+---------------------------
   Reporter:  aperi2007                         |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Data Provider                     |            Version:  Trunk        
   Keywords:                                    |   Platform_version:  7            
   Platform:  Windows                           |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------

Comment(by aperi2007):

 oops,
 the query used is this:

 CREATE VIEW gb.v_volumetria_in_aggetto AS SELECT
     a.id as id, a.codvolumetriainaggetto as codvolinag, a.altezzavolume as
 altezvolum, a.quotaestrusione as quotaestru, c.documentation as codcatuso,
 ST_Union(b.geom) as geom
 FROM
     (( gb.volumetria_in_aggetto a LEFT OUTER JOIN gb.superficie_3d b ON
 (a.codvolumetriainaggetto = b.codvolagg) ) LEFT OUTER JOIN
 gb.zz_categoriausovolumetriaaggettotype c ON (a.codcategoriauso = c.value)
 )
 GROUP BY
     a.id, a.codvolumetriainaggetto, a.altezzavolume, a.quotaestrusione,
 c.documentation
 ;

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3820#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS supporting GDAL/OGR, PostGIS, and GRASS formats, and Web Services