[Qgis-developer] Error for postgres's provider when table(statement SELECT ) is outside public's schema

[Luiz Motta]

Hi Giuseppe ,

The author of provider told me about this problem, see ticket (
https://trac.osgeo.org/qgis/ticket/3329).

The  geometries and SQL are  very simples.

My enviroment is:
1) Windows XP
2) OSGEO4W packages: QGIS 1.6 and Trunk
3) Postgres in Localhost
4) User for Postgres: postgres (administator).
5) SQL :
SELECT
  l.id AS gid, l.the_geom AS the_geom
FROM gis.tl_20101117_101056_limite l

Please inform about your enviroment.
It  can be util for understand what is happened.

Regards,
Luiz Motta





2010/12/14 Giuseppe Sucameli <sucameli at faunalia.it>

> Hi Luiz,
>
> On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <motta.luiz at gmail.com> wrote:
>
>> I am testing the 'Custom database query' plugins, where, i use layers
>> outside public's schema.
>> The plugin create the layer, but, before, i receive the message error
>> about cursor od database.
>> If the layers are inside public's schema not appear message.
>> The one ticket is open, number 3329.
>>
> I'm unable to reproduce it, both 'Custom database query' and 'RT Sql Layer'
> plugins
> seems to work with tables not in the public schema.
> Maybe does your layer contain invalid geometries?
>
> Cheers.
>
> --
> Giuseppe Sucameli
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20101214/f2b90177/attachment.html