<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">Hi Guiseppe,</span><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br>
</span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><div><span class="Apple-style-span" style="border-collapse: collapse;">Sorry for the mistake on the author of the provider.</span></div><div>
<span class="Apple-style-span" style="border-collapse: collapse;"><br></span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">I made both test, for both plugins, 'Custom database query' and 'Rt Sql Layer, and </span></div>
<div><span class="Apple-style-span" style="border-collapse: collapse;">with the same result.</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">When the table is inside public's schema don't have message of error, otherwise, </span></div>
<div><span class="Apple-style-span" style="border-collapse: collapse;">i have the message of error, but the layer is created perfect.</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;"><br>
</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">I saved the project of QGIS (with the created layer) and open again this project the message of error was showed.</span></div><div><span class="Apple-style-span" style="border-collapse: collapse;">In this point isolat the factor of plugin, then, have some problem with provider.</span></div>
<div style="border-collapse: collapse; "><br></div><div style="border-collapse: collapse; ">Regards,</div><div style="border-collapse: collapse; ">Luiz Motta</div></font><br><div class="gmail_quote">2010/12/14 Giuseppe Sucameli <span dir="ltr"><<a href="mailto:sucameli@faunalia.it">sucameli@faunalia.it</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Luiz and Ricardo,<br><br><div class="gmail_quote"><div class="im">On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <span dir="ltr"><<a href="mailto:motta.luiz@gmail.com" target="_blank">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><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><div class="im"><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><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><div class="im"><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><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></div><br><br clear="all"><br>-- <br><font color="#888888">Giuseppe Sucameli<br><br>
</font></blockquote></div><br></div>