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

[Noli Sicad]

Hi Ricardo,

To replicate my error in Spatialite database.

Please download the test-2.3.zip from
http://www.gaia-gis.it/spatialite-2.3.0/resources.html

Do the following query on the Regions table:

Select * from Regions where NAME = "VENETO"

You will see the errors.

Have a look at as well the "sql layer" attribute table.

Using Ubuntu 10.04, GGIS 1.7 trunk r14914M.

Thanks.

Noli
Thanks.

Noli





On 12/16/10, Noli Sicad <nsicad at gmail.com> wrote:
> Hi Ricardo,
>
> In postgis error.
>
> The plugin has the same problem when you checkbox is on for "save new
> layer to database".
>
> However, if I unchecked it this is the error.
>
> ~~~~~~~~~~~~
>
> Unable to execute the query.
> The error message from the database was:
> ERROR:  column "A" does not exist
> LINE 1: ...ect * from (Select * from stands where veg_type = "A") as "s...
>                                                              ^
> .
> SQL: select * from (Select * from stands where veg_type = "A") as
> "subQuery_0" limit 1
>
>
> Noli
>
>
>
>
> On 12/16/10, Noli Sicad <nsicad at gmail.com> wrote:
>> Hi Ricardo,
>>
>> Spatialite database bug.
>>
>> The bug is in checkbox (on./check) "save new layer to database".
>>
>> When I unchecked (off), it works but the resulting map in TOC is "sql
>> layer".
>>
>>
>>
>> The postgis bug, I don't know the reason since it does not work as
>> well in the other postgis plugin (i.e PGManager).
>>
>> Noli
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On 12/16/10, Ricardo Filipe Soares Garcia da
>> <ricardo.garcia.silva at gmail.com> wrote:
>>> Hi Noli
>>>
>>> I can't seem to reproduce any of your errors with my sample data.
>>> Can you give me some more information? What queries are you trying?
>>> Is it possible for you to send me some testing data?
>>>
>>> On Thu, Dec 16, 2010 at 1:47 AM, Noli Sicad <nsicad at gmail.com> wrote:
>>>> Hi Ricardo,
>>>> .
>>>> I got another error in 0.4, this time in PostGI. This is simple query.
>>>>
>>>> Select * from stands where veg_type = "A"
>>>>
>>>> ~~~~~~~~~
>>>> An error has occured while executing Python code:
>>>>
>>>> Traceback (most recent call last):
>>>>  File
>>>> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
>>>> line 175, in parse_SQL_text
>>>>    self.execute_query(selectQuery)
>>>>  File
>>>> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
>>>> line 187, in execute_query
>>>>    self.run_normal_query(createTableQuery, connection)
>>>>  File
>>>> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
>>>> line 238, in run_normal_query
>>>>    cursor.execute(query)
>>>> ProgrammingError: column "A" does not exist
>>>> LINE 1: ...ne.Veg_TYPE_A AS (Select * from stands where veg_type = "A")
>>>>                                                                  ^
>>>>
>>>>
>>>> Python version:
>>>> 2.6.5 (r265:79063, Apr 16 2010, 13:28:26)
>>>> [GCC 4.4.3]
>>>>
>>>>
>>>> QGIS version:
>>>> 1.7.0-Trunk Trunk, 14914M
>>>>
>>>>
>>>> The previous error was in Spatialite.
>>>>
>>>> Thanks.
>>>>
>>>> Noli
>>>>
>>>
>>>
>>>
>>> --
>>> ___________________________ ___ __
>>> Ricardo Garcia Silva
>>> _______________________________________________
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>
>