[Qgis-developer] Error for postgres's provider when table(statement SELECT ) is outside public's schema

[Noli Sicad]

This is spatialite, not PostGIS, hence, pg_manager does not apply :-)

On 12/16/10, Giuseppe Sucameli <sucameli at faunalia.it> wrote:
> On Thu, Dec 16, 2010 at 1:46 AM, Noli Sicad <nsicad at 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.silva at 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.luiz at 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 <sucameli at faunalia.it>
>> >>>
>> >>> Hi Luiz and Ricardo,
>> >>>
>> >>> On Tue, Dec 14, 2010 at 1:04 PM, Luiz Motta <motta.luiz at 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 <sucameli at faunalia.it>
>> >>>>>
>> >>>>> Hi Luiz,
>> >>>>>
>> >>>>> On Tue, Dec 14, 2010 at 2:43 AM, Luiz Motta <motta.luiz at 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 at lists.osgeo.org
>> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> >
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
>
>
> --
> Giuseppe Sucameli
>