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

[Giuseppe Sucameli]

Hi Luiz and Ricardo,

On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <motta.luiz at gmail.com> wrote:
>
> The author of provider told me about this problem, see ticket (
> https://trac.osgeo.org/qgis/ticket/3329).
>
to Luiz: as Ricardo wrote, he is the author of the plugin
(CustomDatabaseQuery),
not the author of the provider at all.
BTW, I'm the author of both the patches for executing a custom query with
postgres and spatialite provider, so I'm one of the guys you're searching
for :)

to Ricardo: the ticket told about an "Error for postgres's provider", not
custom
database query plugin issue.
Furthermore, the QGis trac is not for plugins' issues, except for those that
are
in trunk. For this reason we're working to create a plugins trac.

If you're sure the issue is only related to your plugin source code and not
to the
qgis functions called in your code, you should close the ticket as invalid.

SELECT
>   l.id AS gid, l.the_geom AS the_geom
> FROM gis.tl_20101117_101056_limite l
>

Doesn't anyone confirm that it's a provider's issue, not just a plugin
issue??
Please, could you try to execute the same query using the RT Sql Layer
plugin,
in order to confirm the provider issue?

Thanks a lot.
Cheers.


>
> 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
>>
>>
>


-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20101214/9dbc401b/attachment.html