On Thu, Dec 16, 2010 at 1:46 AM, Noli Sicad <nsi...@gmail.com> 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 > <ricardo.garcia.si...@gmail.com> 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 <motta.l...@gmail.com> > 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 <sucam...@faunalia.it> > >>> > >>> Hi Luiz and Ricardo, > >>> > >>> On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <motta.l...@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 <sucam...@faunalia.it> > >>>>> > >>>>> Hi Luiz, > >>>>> > >>>>> On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <motta.l...@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 > >>> > >> > >> > > > > > > > > -- > > ___________________________ ___ __ > > Ricardo Garcia Silva > > _______________________________________________ > > Qgis-developer mailing list > > Qgis-developer@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/qgis-developer > > > _______________________________________________ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer > -- Giuseppe Sucameli
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer