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

Noli Sicad nsicad at gmail.com
Wed Dec 15 20:47:37 EST 2010


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


More information about the Qgis-developer mailing list