[QGIS-trac] [Quantum GIS] #3329: Error for postgres's provider when table(statement SELECT ) is outside public's schema

[Quantum GIS]

#3329: Error for  postgres's provider when table(statement SELECT ) is outside
public's schema
------------------------------------------------+---------------------------
   Reporter:  lmotta                            |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Data Provider                     |            Version:  1.6.0        
   Keywords:                                    |   Platform_version:               
   Platform:  Windows                           |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 When used layers outside public's schema has problem where layer is
 defined with statement SQL.

 The problem is message of error, but, the layer is created  correct.
 Menssage Error:
 SQL: declare oidcursor binary cursor for select regclass...

 The example of layer:
 dbname='postgis' host=localhost port=5432 user='postgres' key='gid'
 table="(select l.id AS gid, l.the_geom AS the_geom from
 gis.tl_20101117_101056_limite l)" (the_geom) sql=

 When layer are in public's schema is OK.
 ... from public.tl_20101117_101056_limite l

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