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

[Noli Sicad]

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
>