This is spatialite, not PostGIS, hence, pg_manager does not apply :-)
On 12/16/10, Giuseppe Sucameli <[email protected]> wrote: > On Thu, Dec 16, 2010 at 1:46 AM, Noli Sicad <[email protected]> wrote: > >> Is there simple way to delete the table in the database, not using SQL >> statement / query? >> > PG_manager -> delete table/view. Why not? > Cheers. > > Thanks. >> >> Noli >> >> On 12/16/10, Ricardo Filipe Soares Garcia da >> <[email protected]> wrote: >> > Hi all >> > To celebrate the fixing of this bug by brushtyler (Guiseppe maybe?), I >> > have updated 'custom db query' to version 0.4. >> > The plugin's window is now modeless, and it stays on top of the QGIS >> > main window. So you can interact with the rest of QGIS while having >> > the plugin open. This way you can, for example remove your query >> > layers from the map. >> > >> > >> > On Tue, Dec 14, 2010 at 7:03 PM, Luiz Motta <[email protected]> >> wrote: >> >> Hi Guiseppe, >> >> Sorry for the mistake on the author of the provider. >> >> I made both test, for both plugins, 'Custom database query' and 'Rt >> >> Sql >> >> Layer, and >> >> with the same result. >> >> When the table is inside public's schema don't have message of error, >> >> otherwise, >> >> i have the message of error, but the layer is created perfect. >> >> I saved the project of QGIS (with the created layer) and open again >> >> this >> >> project the message of error was showed. >> >> In this point isolat the factor of plugin, then, have some problem >> >> with >> >> provider. >> >> Regards, >> >> Luiz Motta >> >> 2010/12/14 Giuseppe Sucameli <[email protected]> >> >>> >> >>> Hi Luiz and Ricardo, >> >>> >> >>> On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <[email protected]> >> 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 <[email protected]> >> >>>>> >> >>>>> Hi Luiz, >> >>>>> >> >>>>> On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <[email protected]> >> >>>>> 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 >> >>> >> >> >> >> >> > >> > >> > >> > -- >> > ___________________________ ___ __ >> > Ricardo Garcia Silva >> > _______________________________________________ >> > Qgis-developer mailing list >> > [email protected] >> > http://lists.osgeo.org/mailman/listinfo/qgis-developer >> > >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> > > > > -- > Giuseppe Sucameli > _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
