Hi Luiz and Ricardo,<br><br><div class="gmail_quote">On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <span dir="ltr"><<a href="mailto:motta.luiz@gmail.com">motta.luiz@gmail.com</a>></span> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>The author of provider told me about this problem, see ticket (<a href="https://trac.osgeo.org/qgis/ticket/3329" target="_blank">https://trac.osgeo.org/qgis/ticket/3329</a>).</div></blockquote><div>to Luiz: as Ricardo wrote, he is the author of the plugin (CustomDatabaseQuery), <br>
not the author of the provider at all.<br>BTW, I'm the author of both the patches for executing a custom query with <br>postgres and spatialite provider, so I'm one of the guys you're searching for :)<br><br>
to Ricardo: the ticket told about an "Error for postgres's provider", not custom <br>
database query plugin issue.<br>Furthermore, the QGis trac is not for plugins' issues, except for those that are <br>in trunk. For this reason we're working to create a plugins trac.<br><br>If you're sure the issue is only related to your plugin source code and not to the <br>
qgis functions called in your code, you should close the ticket as invalid.<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div>
<span style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;">SELECT</span></div><div><span style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;"> <a href="http://l.id" target="_blank">l.id</a> AS gid, l.the_geom AS the_geom</span></div>
<div><span style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;">FROM gis.tl_20101117_101056_limite l</span></div></blockquote><div><br>
Doesn't anyone confirm that it's a provider's issue, not just a plugin issue??<br>Please, could you try to execute the same query using the RT Sql Layer plugin, <br>
in order to confirm the provider issue?<br>
<br>
Thanks a lot.<br>Cheers.<br> <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><font face="Verdana, Arial, 'Bitstream Vera Sans', Helvetica, sans-serif"><br>
</font></div><div><font face="Verdana, Arial, 'Bitstream Vera Sans', Helvetica, sans-serif"><div>Please inform about your enviroment.</div><div>It can be util for understand what is happened.</div>
<div><br></div><div>Regards,</div><div>Luiz Motta</div></font></div><div><br></div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">2010/12/14 Giuseppe Sucameli <span dir="ltr"><<a href="mailto:sucameli@faunalia.it" target="_blank">sucameli@faunalia.it</a>></span><div>
<div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi Luiz,<br><br><div class="gmail_quote"><div><div></div><div>On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <span dir="ltr"><<a href="mailto:motta.luiz@gmail.com" target="_blank">motta.luiz@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I am testing the 'Custom database query' plugins, where, i use layers outside public's schema.<br>
The plugin create the layer, but, before, i receive the message error about cursor od database.<br>
If the layers are inside public's schema not appear message.<br>
The one ticket is open, number 3329.<br></blockquote></div></div><div>I'm unable to reproduce it, both 'Custom database query' and 'RT Sql Layer' plugins <br>seems to work with tables not in the public schema.<br>
Maybe does your layer contain invalid geometries?<br><br>Cheers.<br>
<br></div></div>-- <br><font color="#888888">Giuseppe Sucameli<br><br>
</font></blockquote></div></div></div><br></div>
</blockquote></div><br><br clear="all"><br>-- <br>Giuseppe Sucameli<br><br>