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

[Ricardo Filipe Soares Garcia da]

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