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 <nsi...@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 <nsi...@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.si...@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 <nsi...@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@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> >> > _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
