[QGIS-trac] Re: [Quantum GIS] #1933: Fix PostGIS dataprovider to check for unique data with SQL where clause

[Quantum GIS]

#1933: Fix PostGIS dataprovider to check for unique data with SQL where clause
-----------------------------------------------------+----------------------
        Reporter:  jpalmer                           |         Owner:  jef                
            Type:  bug                               |        Status:  reopened           
        Priority:  major: does not work as expected  |     Milestone:                     
       Component:  Data Provider                     |       Version:  HEAD               
      Resolution:                                    |      Keywords:  postgis, postgresql
Platform_version:  WinXP SP2                         |      Platform:  All                
        Must_fix:  No                                |   Status_info:  0                  
-----------------------------------------------------+----------------------
Changes (by jpalmer):

  * status:  closed => reopened
  * resolution:  wontfix =>

Comment:

 The case I was wanting to implement already involves a view. It would be
 useful to use the where cause to show different spatial datasets based on
 this view.

 How about modifying the QgsPostgresProvider::setSubsetString method to
 recheck for the unique primary key by calling the
 QgsPostgresProvider::uniqueData() method?

 I would be really great to have this feature so I can build a python plug-
 in to dynamically add and view multiple vector layers based on a dataset
 identifier.

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