<div class="gmail_quote">On Thu, Dec 16, 2010 at 1:46 AM, Noli Sicad <span dir="ltr"><<a href="mailto:nsicad@gmail.com">nsicad@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;">
Is
there simple way to delete the table in the database, not using SQL<br>
statement / query?<br></blockquote><div></div><div>PG_manager -> delete table/view. Why not?<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;">
Thanks.<br>
<br>
Noli<br>
<br>
On 12/16/10, Ricardo Filipe Soares Garcia da<br>
<div><div></div><div class="h5"><<a href="mailto:ricardo.garcia.silva@gmail.com">ricardo.garcia.silva@gmail.com</a>> wrote:<br>
> Hi all<br>
> To celebrate the fixing of this bug by brushtyler (Guiseppe maybe?), I<br>
> have updated 'custom db query' to version 0.4.<br>
> The plugin's window is now modeless, and it stays on top of the QGIS<br>
> main window. So you can interact with the rest of QGIS while having<br>
> the plugin open. This way you can, for example remove your query<br>
> layers from the map.<br>
><br>
><br>
> On Tue, Dec 14, 2010 at 7:03 PM, Luiz Motta <<a href="mailto:motta.luiz@gmail.com">motta.luiz@gmail.com</a>> wrote:<br>
>> Hi Guiseppe,<br>
>> Sorry for the mistake on the author of the provider.<br>
>> I made both test, for both plugins, 'Custom database query' and 'Rt Sql<br>
>> Layer, and<br>
>> with the same result.<br>
>> When the table is inside public's schema don't have message of error,<br>
>> otherwise,<br>
>> i have the message of error, but the layer is created perfect.<br>
>> I saved the project of QGIS (with the created layer) and open again this<br>
>> project the message of error was showed.<br>
>> In this point isolat the factor of plugin, then, have some problem with<br>
>> provider.<br>
>> Regards,<br>
>> Luiz Motta<br>
>> 2010/12/14 Giuseppe Sucameli <<a href="mailto:sucameli@faunalia.it">sucameli@faunalia.it</a>><br>
>>><br>
>>> Hi Luiz and Ricardo,<br>
>>><br>
>>> On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <<a href="mailto:motta.luiz@gmail.com">motta.luiz@gmail.com</a>> wrote:<br>
>>>><br>
>>>> The author of provider told me about this problem, see ticket<br>
>>>> (<a href="https://trac.osgeo.org/qgis/ticket/3329" target="_blank">https://trac.osgeo.org/qgis/ticket/3329</a>).<br>
>>><br>
>>> to Luiz: as Ricardo wrote, he is the author of the plugin<br>
>>> (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<br>
>>> for :)<br>
>>><br>
>>> to Ricardo: the ticket told about an "Error for postgres's provider", not<br>
>>> custom<br>
>>> database query plugin issue.<br>
>>> Furthermore, the QGis trac is not for plugins' issues, except for those<br>
>>> 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<br>
>>> not to the<br>
>>> qgis functions called in your code, you should close the ticket as<br>
>>> invalid.<br>
>>><br>
>>>> SELECT<br>
>>>> <a href="http://l.id" target="_blank">l.id</a> AS gid, l.the_geom AS the_geom<br>
>>>> FROM gis.tl_20101117_101056_limite l<br>
>>><br>
>>> Doesn't anyone confirm that it's a provider's issue, not just a plugin<br>
>>> issue??<br>
>>> Please, could you try to execute the same query using the RT Sql Layer<br>
>>> plugin,<br>
>>> in order to confirm the provider issue?<br>
>>><br>
>>> Thanks a lot.<br>
>>> Cheers.<br>
>>><br>
>>>><br>
>>>> Please inform about your enviroment.<br>
>>>> It can be util for understand what is happened.<br>
>>>> Regards,<br>
>>>> Luiz Motta<br>
>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>> 2010/12/14 Giuseppe Sucameli <<a href="mailto:sucameli@faunalia.it">sucameli@faunalia.it</a>><br>
>>>>><br>
>>>>> Hi Luiz,<br>
>>>>><br>
>>>>> On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <<a href="mailto:motta.luiz@gmail.com">motta.luiz@gmail.com</a>><br>
>>>>> wrote:<br>
>>>>>><br>
>>>>>> I am testing the 'Custom database query' plugins, where, i use layers<br>
>>>>>> outside public's schema.<br>
>>>>>> The plugin create the layer, but, before, i receive the message error<br>
>>>>>> 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>
>>>>><br>
>>>>> I'm unable to reproduce it, both 'Custom database query' and 'RT Sql<br>
>>>>> 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>
>>>>> --<br>
>>>>> Giuseppe Sucameli<br>
>>>>><br>
>>>><br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>> Giuseppe Sucameli<br>
>>><br>
>><br>
>><br>
><br>
><br>
><br>
> --<br>
> ___________________________ ___ __<br>
> Ricardo Garcia Silva<br>
> _______________________________________________<br>
> Qgis-developer mailing list<br>
> <a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
><br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Giuseppe Sucameli<br><br>